Hide specific rows

gmaiolico · 2024-11-07T11:48:41+00:00

There was an error rendering this rich post.

Hi BOARD Community,

I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below

I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot.
With that being said, how can i hide the undesired rows?

Find more posts tagged with

Cube

Dataview

Accepted answers

All comments

Adrien Albrespit

Hi,

Adding an algorithm with IFs taking as inputs your dimensions and that will return value = 0 for the undesired combinations and 1 for the ones that you need + then adding a filter on that data block to exclude 0 values could be an option if there aren't too many possible combinations to exclude/include.

Best regards,

Adrien

Adrien Albrespit

If the conditions are too complex, you could consider to flag the combinations in an additional cube and use it in your dataview as filter or in an algorithm multiplicating the data of your real cube by the value on this flag cube (0 or 1) according to the validity of the combination.