1 Reply Latest reply: Mar 8, 2011 3:40 PM by Anil Konduri RSS

    Help with Partial sum in pivot table

    Anil Konduri

      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.