8 Replies Latest reply on Jul 14, 2016 8:00 AM by swaroop.gantela

    Sum accross multiple dimensions in Table

    Béatrice LORIOT

      Hello everyone,

      This may be a simple question but I can't get the solution.... I need to reorganise the following data

       

       

      into the following table

       

      I will certainly need to Sum Rate 1 and 4 as well,  and 3 and 4, etc, and it seems that Groups are not applicable for that.

       

      What would be the solution ? Create a calculated field ? Bu It can't find out what the syntax is for the calculation.

       

      Thanks for your help,

      KR

      Béa