- ☰ Contents
**General****Setup****Edit Evaluations****General****Data Sheets****Connected Sheets****Other Sheets****Extended****Execute Evaluations**- My Excel Evaluations
- Execute Excel Evaluation
- Evaluation Filters
- Archive Excel Evaluation
- Evaluation Archive
- Analyze Data in Excel
**Information for Developers****Appendix**

Docs / Excel Report Builder / Edit Evaluations / Connected Sheets

# PivotTable Field Settings

2023/12/01 • 5 min. to read

#### In this topic

The **PivotTable Field Settings** page is used to set up a field of a PivotTable.
Depending on the type of PivotTable field, different field settings are available.

2023/12/01 • 5 min. to read

Subtotals | Specifies whether subtotals should be calculated. |

Sum | Specifies whether the the sum of the values should be calculated. This is the default function for numeric data. |

Count | Specifies whether the the number of data values should be calculated. Count is the default function for data other than numbers. |

Average | Specifies whether the average of the values should be calculated. |

Max | Specifies whether the largest value should be calculated. |

Min | Specifies whether the smallest value should be calculated. |

Product | Specifies whether the product of the values should be calculated. |

Count Numbers | Specifies whether the number of data values that are numbers, should be calculated. |

StdDev | Specifies whether an estimate of the standard deviation of a population, where the sample is a subset of the entire population, should be calculated. |

StdDevP | Specifies whether the standard deviation of a population, where the population is all of the data to be summarized, should be calculated. |

Var | Specifies whether an estimate of the variance of a population, where the sample is a subset of the entire population, should be calculated. |

VarP | Specifies whether the variance of a population, where the population is all of the data to be summarized, should be calculated. |

Sort by | Specifies whether the data should be sorted by a particular field. |

Sort | Specifies whether the data should be sorted in ascending or descending order. |

Filter by | Specifies whether the data should be filtered by a particular field. |

Filter | Specifies the type of filter. |

Filter Value, Filter Value 2 | Specifies the parameters of the filter. |

Summarize Values By | Specifies whether and how the values should be summarized. For more information about sum values in a PivotTable, see: https://support.microsoft.com/en-us/office/9ee73790-646a-42c9-9fc7-e1ca30096d9c |

Show Values As | Specifies if the values should be shown in a different way or calculation. For more information about different calculations in PivotTable value fields, see: https://support.microsoft.com/en-us/office/014d2777-baaf-480b-a32b-98431f48bfec |

Position and Layout | |
---|---|

Slicer Style | Specifies a style for the Slicer. If the field is empty, the default setting from the Excel Evaluation Setup will be used. |

Left Position (cm) | Specifies the position of the slicer.
If no value is specified, the position is calculated from the position + width of the previous slicer. |

Top Position (cm) | Specifies the position of the slicer. If no value is specified, the value of the previous slicer is used. |

Number of Columns | Specifies the number of columns in the slicer. |

Button Height (cm) | Specifies the height of the slicer buttons. |

Size | |

Height (cm) | Specifies the height of the slicer. If no value is specified, the value of the previous slicer is used. |

Width (cm) | Specifies the width of the slicer. If no value is specified, the value of the previous slicer is used. |

**Finmatics Autonomous Accounting**

Interface for AI-driven document processing tool by Finmatics.

More information

AppSource