Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
I thought using the match function would allow me to do this but it doesn't work.
Any ideas?
Finbar
in your expression you should use something as below:
=if( ValueList('< 15k','15k-30k') = '< 15k', your_expression_1,
if( ValueList('< 15k','15k-30k') = '15k-30k', your_expression_2 ) )
hope this helps.
Hi,
you should be able to solve this using ValueList() function
read this:
Hi youssefbelloum,
I am using it like this but it doesn't recognize it. Should I be referencing the filed name somewhere too?
=ValueList('< 15k','15k-30k')
Regards
Finbar
did you read carefully the help ?
did you use it in the dimension expression AND the measure expression ?
in your expression you should use something as below:
=if( ValueList('< 15k','15k-30k') = '< 15k', your_expression_1,
if( ValueList('< 15k','15k-30k') = '15k-30k', your_expression_2 ) )
hope this helps.