Help with Partial sum in pivot table

[#1]

Hi All, I am using

=If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] <= [Month_Yr], Sum(Amt), if([End_Month_Yr] >= [Month_Yr], Sum(Amt), 0))

as pivot chart expression. But the Total ( partial sum) populating zeros, why its not populating the Total?

Please Help. Thanks in Advance.

[#2 · Accepted solution]

I got it...

Changed my expression as

=Sum(If(ISNULL(End_Month_Yr) AND [Start_Month_Yr] <= [Month_Yr], Amt, if([End_Month_Yr] >= [Month_Yr], Amt, 0)))