I have a pivot table, with the categories and products on the left, and a column with average amounts, but when I pressed the show total button the system took me the average of the results and what I need is the SUM of the results of the average. How can I get this calculation?
Try aggregation function like below.
Where do i put the formula? in a new dimension? the first number is total (right now is calculating the average of the rest numbers in the column, i would like to have the sum in the same place. Instead of 11k, should be maybe 340k aprox.
Create a variable (for example vVar).
Set the definition of the variable to =Sum(Aggr(Avg(Amount), Category, Product))
Then change your expression in your pivot table:
=IF(Dimensionality() = 0, vVar, Avg(Amount))