This content has been marked as final. Show 4 replies
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.