Formatting of multiple Member Filters in CubeView

[BenvanBergen]

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 of these would need a different format to make it easer to recognize them, if I make a separate row the grouping on the primary filter will be gone.

Is there a code that can be used after a member filter to apply formatting?

A solution in either the cubeview, or Excel AddIn would be helpful.

Thanks in advance

Ben

[Manasa · Accepted solution]

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]

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

Appreciate the really quick reply!