Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Thanks in advance
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'}>}
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'}>}
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