2 Replies Latest reply: Jan 23, 2014 2:09 PM by Bill Markham

# Hide a row in straight table

Hello Guys,

I have a straight table with 15 dimensions and 3 expressions  and many rows for each dimensions and expression in that I have to hide particular rows of one dimension called ABC with particular values like 123, 456, 789, 987, 654, 321

how can I hide a column ABC with only particular values ?

• ###### Re: Hide a row in straight table

For your ABC dimension, create a calculated dimension instead and suppress values when null.  Calculated dimension should be something like:

if(not match(ABC, '123', '456', '789', '987', '654', '321'), ABC)

or

aggr(only({\$-<ABC={'123', '456', '789', '987', '654', '321'}>}ABC), ABC)

Or you can use this same set analysis in your expression(s): {\$-<ABC={'123', '456', '789', '987', '654', '321'}>}

• ###### Re: Hide a row in straight table

Dinesh

Assuming when you mean hide the row and not the column, then either use a calculated dimension or set analysis in the expressions.

Best Regards,     Bill