13 Replies Latest reply: Feb 5, 2016 2:44 AM by jagan mohan rao appala RSS

    Pivot Table - How to use total partial sum value to create another expression

    Jim Chan

      Hi guys,

       

      I have created a pivot table, 1st expression called No. of checks(expression count(checks). That is fine. then i enable to Total Partial Sum. it gaves me a total of no.checks.

       

      So now, my client want to know % checks - the measurement given by client is  - each number of check(1) / use total no. of checks(12)

       

      1/12 = 0.083 x 100 = 8.3 %.

       

      I couldn't get the value of  % checks.

      error.png

       

      Rgds,

       

      Jim