7 Replies Latest reply on Feb 14, 2019 11:54 PM by Ajith Suresh

    How to edit grand total for a particular measure column

    Ajith Suresh

      Hi All,

       

      I have a workbook with measure values like sum(revenue) ,avg(Plan), Revenue-Plan & Revenue/Plan. I am able to see correct grand totals for all measure columns except Revenue/Plan.

       

      PFB Screenshot for reference:

       

      Revenue/Plan have to divide total(Revenue) with total(Plan), then we are supposed to get 130%. But in this case we are getting Total percentage of individual column values ie.,(224+68).. Could any one of you have an idea about the solution for this. i am also attaching a sample workbook for further details.

       

       

      Thanks in Advance,

      Ajith V S.