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.

[rbecher]

Hi Brandon,

just try function:

     ValueList('Hot', 'Cold')

as a calculated dimension.

- Ralf

[swuehl]

Try

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

edit:

Oh, I just thought I have already answered the question but forgot to commit 😉