Conditional Dimension

[#1]

I have created a pivot chart with three dimensions.

On one of the dimensions, I would like for it not to show a certain value.  If the value happens to be 'Other' then I don't want it to show up in my chart.

I have tried doing it under the enable condition for the selected dimension but it doesn't seem to work.

Any suggestions?????

[jonathandienst · Accepted solution]

Hi

Use a calculated dimension:

     =If(Dimension <> 'Other', Dimension)

     or

     =Aggr(Only(If(Dimension <> 'Other', Dimension)), Dimension)

Or use exclude it in the expressions:

     =Sum({<Dimension -= {'Other'}, ......)

(where Dimension is the name of your dimension field)

HTH

Jonathan

[jerem1234]

You will have to use a calculated dimension, something like:

If(FIELD <> 'Other', FIELD)

This way the values that have the value 'Other' will be mapped to null, and the rest stay as they are.

Hope this helps!

[jonathandienst]

Oh, and check the Suppress if null option for that dimension...