Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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