Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Adrianus,
Sum({<Category-={'Red'}>+<Type-={'Low'}>} Value)
or
Sum(If(Category <> 'Red',Value,If(Type <> 'Low',Value)))
Regaards,
Antonio
Thank you Antonio,
I'll try your formula and inform you the result...