20 Replies Latest reply: Oct 23, 2012 6:00 AM by Leni Balakrishnan RSS

    To show sub total as 100% in pivot table

    Leni Balakrishnan

      Hi,

       

      I want to show the values in my pivot table as 100% for each sub total

       

      I need to show my pivot table like below

       

       

      Cg1Cg2
      Expr1

      Expr2


      Total100%100%
      xxxaaa25%50%

      bbb25%30%

      ccc50%20%

      Total100%100%
      yyyddd10%60%

      eee70%40%

      fff20%-

      Total100%100%
      zzzggg15%90%

      hhh75%10%

      iii10%-




       

      Now I can show the partial total by doing the settings on Presentation tab.

       

      My concern is I am getting the overall total as 100% but not the each sections total as 100%. The 100% should be shown for all fields in the cyclic groups.

       

      So What should I do to get 100% value in each section??

       

      Can anyone help me in this??

       

      Thanks in Advance

       

      Regards,

      Leni