Calculated dimensions

[#1]

How do I only use certain records of my dimension field?  Example I have a field with (Hot, Cold, Warm) as the possible values.  I want to only have Hot and Cold as the ones that show up in my graph fot that dimension.

[swuehl · Accepted solution]

Maybe like

=if(match(YOURFIELD,'Hot','Cold'),YOURFIELD)

as calculated dimension, and check supress when Value is NULL in dimension tab.

[#3]

Thanks swuehl, as usual you got it!  Only thing is I'm still left with an empty spot in addition to the 'hot' and 'cold' field.  How would I suppress that?

[swuehl]

Have you checked the 'Suppress when Value is NULL' in dimension tab?

If so, how does your table look like? What do you mean with empty spot?

[#5]

Awwh swuehl!  A smart one you are!