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




      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: