3 Replies Latest reply: Jun 13, 2018 1:26 AM by Praveen Purushothaman Branched from an earlier discussion. RSS

    Re: Add a Total Value to the Pivot Table

    Praveen Purushothaman

      !Hi Anyone,

      I have the pivot table with totals now.

      How can I get the percentage by programs?

      I have added a expression =count([G-code])/Count(TOTAL [G-code]) but this gives the percentage by taking the overall total.

       

      For example for G-Code A the percentage I want is 1/1=100% but the above expression gives 1/8 which is 0.125.

       

      Any help?

      I tried various combinations of Aggr (my level) but no use.

      Thanks!