Forum Discussion
Matrix Visualization: Hide Subtotals with a Blank Description
My data set it is using a hiarchal structure that does not require a value in each level of the hiarchy. This causes several subtotal line to appear as blank lines in the matrix and add extra subtot...
Thank you for your reply Cherry, This solution doesn't really work for my issue.
In my data set I don't have any lines with 0 values, but I do have lines with missing values in L3, L4, and L5 header. Here is a sample of what the data looks like:
The problem comes in because not ever line has a value for L3, L4, L5, but some do. Since I'm grouping the rows by that field it will used the blank value in there and treat it as if there was a value.
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous,
If I understand your requirement correctly that you want to hide the rows highlight in red?
If it is, you could use the solution I mentioned for the first reply, may be you could try is not blank.
Best Regards,
Cherry