Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
please provide some sample data and sketch the desired result...
try like below
Sum ( AGGR ( YourExpression , FiedinDimension) )
use below expression
AVG( total <Contry> Sales)
Now check partial sum option in presentation tab