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

    Pivot Table - Calculated Dimensions

    Finbar Gillen

      Hi,

       

      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'

      qlik.JPG

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

       

      Any ideas?

       

      Finbar