Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)))
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)))