How can a get a sum result from averages results in a pivot table?

[#1]

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?

Thank you.

[kaushiknsolanki]

Hi,

Try aggregation function like below.

Sum(Aggr(Avg(Amount),Category,Product))

Regards,

Kaushik Solanki

[sunny_talwar]

May be like this

Sum(Aggr(Avg(Amount), Category, Product))

[#4]

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.

Thank you.

[sunny_talwar]

Replace your existing expression with this

Sum(Aggr(YourCurrentExpression, Category, Product))

[#6]

I wanted to sum just the total field.  Now is SUM everything. =S

[sunny_talwar]

Would you be able to share your qvf file or a sample to help you better here?

[marioglasmv]

Try this.

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))