How to filter the dimension?

[Anonymous]

Hi All,

I have field named 'Category' values red, yellow and green and maned 'Type' values high, middle and low.

Now I put it into Chart dimension, I don't want to show Type low in this dimension if Category is red, how to filter it?

[antoniotiman]

Hi Adrianus,

Sum({<Category-={'Red'}>+<Type-={'Low'}>} Value)

or

Sum(If(Category <> 'Red',Value,If(Type <> 'Low',Value)))

Regaards,

Antonio

[Anonymous]

Thank you Antonio,

I'll try your formula and inform you the result...