Expression in Pivot Table

[#1]

My Pivot table report is somehow looks like

To calculate the "Diff " column value I am using the expression

=if (Count ({$<PeriodName={$(=date(addmonths(PeriodName,-1)))}>} Amount) > 0, 1, 0)

Returning "1"or "0" just to check that expression is working fine, but its not working. Even though Amount is there for April, its returning "0" for May month.

Please do suggest where I am doing wrong in expression.

Thanks.

[MayilVahanan]

hi

use datefield in set analysis..addmonths(periodname,-1) is not datefield...from ur image

[#3 · Accepted solution]

Hi Mayil,

I have tried that also but no success.

Anyways I got the expected result using the expression

=if( ColumnNo( )<>1,sum(Amount) - before(sum([Amount])) , 0 )