8 Replies Latest reply on Jul 20, 2016 7:15 PM by Shesil Parmar

    How to calculate % of total ?

    Shesil Parmar

      Hi,

       

      I'm struggling to calculate % of total sum. I have attached a sample book if someone can assist me !

       

      I have created 3 calculated field but still unable to achieve what i'm after.

      so basically i want, % of P1, T1 and MD1 of that selected month, i do get % but its based on total count (its field name actually) so whenever i change month or charge group , it changes % as well.

       

      this is what is should be

       

      ChargeGroupJan-16Feb-16May-16Dec-15
      P10.00%0.64%25.04%2.41%
      T11.77%19.42%21.35%1.77%
      MD117.01%2.73%4.17%3.69%

       

      thank you so much