2 Replies Latest reply on Oct 8, 2018 8:17 AM by Ewa McKillop

    Calculate difference in measures of one (core) dimension vs other dimensions

    Ewa McKillop

      Hello

       

      I am trying to add a calculation where I will be able to compare every measure i.e. AUP, £/kg for MANUFACTURER vs COMPETITOR 1 and MANUFACTURER VS COMPETITOR 2 for each year so that in this table there will be two more sections i.e. index vs competitor 1 and index vs competitor 2 (see below snapshots)

       

      E.g.Calculation will be : MANUFACTURER'S AUP 2015/ COMPETITOR 1's AUP 2015 (%) etc.

       

      I've erased any confidential information, but hope this gives you an idea. I would be grateful for your help Thanks

       

      Current table:

       

      Future table: