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

    How to calculate % of total ?

    Shesil Parmar



      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




      thank you so much