Forum Discussion
How to create Matrix Headers?
danextian OwenAuger
I've run into an unexpected issue after implementing the solution.
Measures that result in "0" are not being popluated in my matrix. This occurs when the Matrix is filtered to only show limited CHANNEL_NAME where there may not be values for each column (Actual, PY, Budget, % vs PY, % vs Budget)
Each category (Spend, Revenue, Calls, Conversions) should have a column for Actual, PY, Budget, % vs PY, % vs Budget).
You can see in the screen capture that the "Spend" category is missing Actual.
The "Revenue" category is missing Actual, PY, % vs PY.
The "Calls" category is missing Actual, PY, % vs PY.
The "Budget" and "% vs Budget" are showing becuase I've set those measures = " ".
Is there anything I can do to correct this to show each column shows even if there is no value?
- OwenAuger1 year ago
Super User
Hi again ERing ,
Good point! Columns with all blanks are hidden by default.
I would recommend selecting "Show items with no data" on the Column fields only (assuming that is where the measures are placed).
This will ensure that all measure columns are always displayed regardless, without introducing unwanted nonblank measure values.
Does this work for you?
- ERing1 year ago
Post Partisan
Wonderful! I'm glad it was an easy fix.