SummaryTypes

12 Sep 20252 minutes to read

Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are,

  • Sum - Allows to display the pivot table values with sum.
  • Product - Allows to display the pivot table values with product.
  • Count - Allows to display the pivot table values with count.
  • DistinctCount - Allows to display the pivot table values with distinct count.
  • Min - Allows to display the pivot table with minimum value.
  • Max - Allows to display the pivot table with maximum value.
  • Avg - Allows to display the pivot table values with average.
  • Median - Allows to display the pivot table values with median.
  • Index - Allows to display the pivot table values with index.
  • PopulationStDev - Allows to display the pivot table values with population standard deviation.
  • SampleStDev - Allows to display the pivot table values with sample standard deviation.
  • PopulationVar - Allows to display the pivot table values with population variance.
  • SampleVar - Allows to display the pivot table values with sample variance.
  • RunningTotals - Allows to display the pivot table values with running totals.
  • DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field.
  • PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field.
  • PercentageOfGrandTotal - Allows to display the pivot table values with percentage of grand total of all values.
  • PercentageOfColumnTotal - Allows to display the pivot table values in each column with percentage of total values for the column.
  • PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row.
  • PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field.
  • PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column.
  • PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row.
  • CalculatedField - Allows to display the pivot table with calculated field values. It allows user to create a new calculated field alone.

    It is applicable only for relational data source.