Hello, 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?
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.