2 Replies Latest reply: Jan 13, 2015 7:15 AM by Prashant Sangle RSS

    Partial Sum calculation in Pivot table

      Hi Team,

       

      Here I have attached sample qvw.

      My Requirement,

      1. I need to convert negative numbers [sum(F1-F2)] to zero,for that purpose i have used Range max function

      2. I have to calculate Partial sum,while calculating it takes the negative numbers too.But In straight table it is working perfectly

       

      Could you help me to solve this issue.

       

      Thanks in advance.

       

      Capture8.PNG