2 Replies Latest reply: Jul 16, 2013 9:11 AM by Azam Mullick RSS

    Pivot table - Relative values to one value



      I have a pivot table with one dimension as rows (level), and another as columns (location).


      I have a master location (eg London), and I want to show the median totals for this location.


      I want all of the other locations to be calculated based on their relativity to London.


      So row one would look like this


      Level     Loc1     Loc2     Loc3     Loc4     London

      a               -15%     20%     25%     -8%     100,000


      Is this possible?


      I have tried saving the London value as a variable, and this doens't work.


      Would it be easier to create 5 columns, each individually calculated as the median total for each location, rather than using a pivot table?