Limiting rows displayed in a Pivot or Straight table based on a dimension value

[#1]

Trying to supress a row of data measures based on the value for the dimension.  For example, I have three columns of data, the first being a Dimension (FV Level) and the other two (CY Value, PY Value).  I believe the way do this is by using the Settings for Selected Dimension:Enable Conditional.  I'm unclear on what syntax I need to use when trying to limit.  Essentially I want to show rows where the FV Level <> (not equal) to "[NULL]". Any thoughts or ideas?

[Anonymous]

Hi

Select Properties, tag dimensions the option Suppress When Value is Null

I hope help you!

[#3]

Jannet,

Thank you for your prompt response, however, I tried that and realized the value is a text string "[NULL]" and not an actual [NULL] value.  The data I'm using is coming straight out of an excel spreadsheet and not a relational database.

Jeff

[#4]

[Anonymous]

Try,

Add Calculated Dimension,

=if([Fair Value Level]<>'[NULL]',[Fair Value Level])

[Anonymous · Accepted solution]

The "Settings for Selected Dimension:Enable Conditional" is to either show or hide a dimension completely based on the condition you put in there. If you don't want to show a value from a dimension..

Add a calculated dimension like this instead...

if([Fair Value Level]<>'[NULL]',[Fair Value Level])  and make sure 'suppress when value is null' is checked..

[#7]

Thank you both.  The formula Jannet provided worked and I did have to select the check box for 'Suppress when value is null'.