Excluding Specific Items from a Dimension

[#1]

I have included a Dimension in my straight table that has a number of different sections, i.e. Hardware, Software, Licences, Services however within this table I would like to always exclude some of these.  Rather than put Set Analysis into each of these is it possible to set something within this Dimension to always exclude certain sections within this table.  e.g. of the list above how could I always exlude Hardware and Software from the Dimension, within this table only.

[swuehl]

You can use a calculated dimension, something like

=if( not match(DIMENSIONFIELD,'Software', 'Hardware'), DIMENSIONFIELD)

[#3]

Thanks Swuehl however this only creates a new dimension and replaces the description of Software & Hardware with a - rather than exlcuding them altogether.  Do you have any further suggestions?

[swuehl · Accepted solution]

You may need to check option 'Supress when Value is NULL' on dimension tab.

[#5]

Excellent, thanks, works a treat