Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table other totals

I Have a pivot table and i want the subtotals to be calculated as a sum of the rows on the most aggregated level.

Example: I want to see 350 as a result of the subtotal in my pivat table and not 383

When using a straight table i can simply go to expressions and change the total mode, with pivot table i can't

What should i do ?

problem.png

3 Replies
Anonymous
Not applicable
Author

please provide some sample data and sketch the desired result...

vinieme12
Champion III
Champion III

try like below

Sum ( AGGR ( YourExpression , FiedinDimension) )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Kushal_Chawda

use below expression

AVG( total <Contry> Sales)

Now check partial sum option in presentation tab