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 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
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
