Hide specific rows

gmaiolico
gmaiolico Active Partner
Name Dropper First Comment Photogenic
in Platform

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

image.png

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?

Tagged:

Answers

  • Adrien Albrespit
    Adrien Albrespit Employee
    10 Comments 5 Likes First Answer Level 300: Expanding Board in Your Organization

    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
    Adrien Albrespit Employee
    10 Comments 5 Likes First Answer Level 300: Expanding Board in Your Organization

    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.

Categories