Calculating Values with Dimension Columns

Platform
1

Is it possible to generate a calculated value using dimension columns within the pivot table?

2

Hi @anusha.venkatachalam

Yes, it is possible to generate a calculated value using dimension columns within the pivot table. Dimensional columns support the following functions:

  • Count
  • Distinct Count
  • % of Grand total
  • % of Column
  • % of Row
  • % of Parent Column Total
  • % of Parent Row Total
  • Index
  • Difference of Column
  • Difference of Row
  • % Difference of Column
  • % Difference of Row
  • Running Totals of Column
  • Running Totals of Row