colour on dimension when missing value in first column
does anyone have an idea how to have all the dimension rows colored in case there are some missing values in the first column of expression? 'if' on background color does not help in such case. Example attached.
Disable the Suppress Zero-Values option. You will get zeros in your table, but every dimension value will get its color. If you don't want zeros shown you can change the number format of the expression on the numbers tab. Select for example the option Fixed and use this format string: # ##0;-# ##0;-. See attached qvw.
Are you referring to the 'Q' column? If so, this field is required to break down your quarters, unless you set up a different expression for each quarter. Alternatively, set the text colour on the header to be =white() and collapse the column as much as possible. There is no 'Suppress Header Row' within Pivot Tables though.
If you are not referring to column 'Q' then an example would help us to help you.