Forum Discussion

BenvanBergen's avatar
BenvanBergen
Contributor
2 years ago

Formatting of multiple Member Filters in CubeView

Hello, For purpose of grouping we have some accounts listed as member filter in a single row: A#VOL_O_StockWIP:Name(Opening Stock Volume), A#VAL_O_StockWIP:Name(Opening Stock Value) etcetera Some ...
Cube View
Excel Add In
  • Manasa's avatar
    Manasa
    2 years ago

    Hi,

    In the header/cell format section for that row, you can add one of the below conditions as per your requirement,

    Based on Member Name:

    Based on Display Text:

    Note: make sure that the Level 1 Member filter dimension Type for that row is set to Account for the above conditions to work, if that's not the case, change the Row Expansion level accordingly. 

    Thank you,

    Manasa

     

Manasa's avatar
Manasa
New Contributor III

Hi,

In the header/cell format section for that row, you can add one of the below conditions as per your requirement,

Based on Member Name:

Based on Display Text:

Note: make sure that the Level 1 Member filter dimension Type for that row is set to Account for the above conditions to work, if that's not the case, change the Row Expansion level accordingly. 

Thank you,

Manasa

 

BenvanBergen's avatar
BenvanBergen
Contributor
2 years ago

Thanks Manasa, that is something I have seen before, but totally forgot about it. It's definitely working well.

 

Appreciate the really quick reply!