Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to to create a Master Item to be used as a Dimension in some of my charts. I need to show only the streets with more than 9 houses.
I tried the following:
=if([STREET]=(Sum(NUM_OF_HOUSES)>=10),[STREET],Null())
But it returns an Invalid Dimension, any ideas?
Thanks in advance.
if( aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())
if( aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())