excluding a field in a dimension - easy answer?

[#1]

Hi collective,

I am building a pivot table and one of the dimensions contains a text string "No abnormalities detected". All I want to do is exclude this statement and any associated data from the pivot table. If it was a set analysis I want the set  of everything that was not "No abnormalities detected". Any ideas how to do this?

I am sure its pretty easy but I'm a noob!

[Anonymous · Accepted solution]

Hi there,

Try this:

Choose on the dimensions tab: Add calculated dimension.

Type: =if(your_dimension<>'No abnormalities detected', your_dimension)

Make sure you check the box Supress When Value Is Null.

Kind regards,

Henco

[#3]

Of course the good old if expression!

Thanks Henco - apprecated!