Subtotals in pivot table

[Anonymous]

Hi All

I am creating a pivot table with two fields Amount and Net.Expressions are as follows:

If(ACCT1=ACCT2,If( Currency='CAD',Money(Sum(Amount),'$ #,##0.00;$ -#,##0.00')),0),but I need an expression without using sum field in my expression like If(ACCT1=ACCT2,If( Currency='CAD',Money(Amount,'$ #,##0.00;$ -#,##0.00')),0).I am getting correct values for this expression,but problem is it is not showing subtotals since I am not using sum in the expression.

Can anyone please help so that I can get subtotals also by using second expression

[Anonymous]

Now I see your problem, you make use of nested aggregations...

try:

Sum(If(ACCT1=ACCT2,If( Currency='CAD',Money((Amount),'$ #,##0.00;$ -#,##0.00')),0))

instead...