Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?????
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
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
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!
Oh, and check the Suppress if null option for that dimension...