Is there a cell formatting based on the display of column header 3 to 6?
Hi all,
I am exploring the functionality of cell formatting based on the text of column header 3-6, I noticed there is a conditional formatting ColE1HeaderDisplayText and ColE2HeaderDisplayText, but not sure if the same function could be applied to header 3 -6 as well. Thank you.
These settings refer to the Column level nesting. ColE1 is Level 1 DIM selection and ColE2 is level 2. Similarly RowE1 refers to the Row Level 1 DIM definition and Member Filter set up. Note that for Columns, you are limited to 2 levels whereas for Rows, you are limited to 4 levels.
The Column Headers column settings you show influences the Header Text. Think of these as overrides. If you Column Level DIM definitions contain V# S# and T# but the order by default is not how you would like to show it or you would rather it include E#, you can accomplish this through this setting up to 6 DIMs.
If your objective is the conditionally format Column 3 to 6 of your CubeView, you can consider using ColName and declare the column name to apply format. In this way, even if you insert a column in the future, as long as the Column Name remains unchanged, your conditional formatting will apply as expected.
Hope that helps
