Elements that contain data after zero suppression
Posted: Sat Oct 25, 2014 12:37 pm
Hello all,
Suppose you are creating a view with 1 dimension in the rows section, no zero suppression, 1000 rows remain.
Then you turn on zero suppression, say 200 rows remain.
All fine and dandy.
I would very much welcome to be able to select only the elements in the current subset (in the rows dimension) that really have data after zero suppression. Say, 200 elements out of 1000.
This means, hiding the 800 elements, which are not useful in the given context. Na manually selecting elements that remain as valid combinations.
What do others think ? Or is there a trick I am unaware of (besides snapshotting to Excel or MDX or TI process) ?
Enjoy the weekend,
Wim
Suppose you are creating a view with 1 dimension in the rows section, no zero suppression, 1000 rows remain.
Then you turn on zero suppression, say 200 rows remain.
All fine and dandy.
I would very much welcome to be able to select only the elements in the current subset (in the rows dimension) that really have data after zero suppression. Say, 200 elements out of 1000.
This means, hiding the 800 elements, which are not useful in the given context. Na manually selecting elements that remain as valid combinations.
What do others think ? Or is there a trick I am unaware of (besides snapshotting to Excel or MDX or TI process) ?
Enjoy the weekend,
Wim