1 Reply Latest reply: Nov 15, 2017 4:46 PM by omar bensalem RSS

    Filtering a dimension based on a condition.

    Bernardo Araujo

      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.