Pivot Table

[Anonymous]

Hello there,

I got help last time to build a total on a pivot table. Now I need more help to make the sum of the totals. On the attachment there is an example.

This is the expression for the total on the Class level.

How can I have the Total on the Category level?

The result of both totals must be 21600+29700=51300

Thanks in advance.

[MayilVahanan · Accepted solution]

Hi

Try like this

=if(rowno()=0 or IsNull(RowNo()),SUM(AGGR((sum(Amount)-(Value*max(total<Category>aggr(SUM(Amount),Category,Class,Code))/1000))*Price,Type,Category,Class,Code)),Column(6)*Column(7))

[Anonymous]

Thanks Mayil

It works nice!