4 Replies Latest reply: Apr 24, 2018 6:25 AM by Andrea Gigliotti RSS

    Pivot Table - Calculated Dimensions

    Finbar Gillen



      I have simple pivot table where I am getting the sum of population of areas within the different catchments below.


      However I want to create new calculated dimensions within the pivot table like;

           '< 15k' + '15k-30k'

      and '< 15k' + '15k-30k' + '30k-50k'

      and '< 15k' + '15k-30k' + '30k-50k' + '50k-100k'


      I thought using the match function would allow me to do this but it doesn't work.


      Any ideas?