Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
4 months ago

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, bu...
  • TGG_Alex's avatar
    4 months ago

    Jacky_C 

    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