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

    Pivot table - Relative values to one value

      Hi,

       

      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?

       

      Thanks,

       

      Joe