Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently, we have a pivot table, it will show all dimension value when all has value.
Some dimension value will hide after we select period time.
e.g.
Dimension 1 asset risk: High, Medium, Low
Dimension 2 client risk: High, Medium, Low
Table format:
Client Risk High Medium Low
Asset Risk
High 3 6 4
Medium 4 7 2
Low 5 8 7
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
It will be shown as below after select period time
Client Risk Medium Low
High 6 4
Medium 7 2
Low 8 7
My problem is, how to show null value or missing value for Client Risk dimension. And want to show it as below after select period time.
High 0 6 4
Medium 0 7 2
Low 0 8 7
Is there any approach to solve above problem?
Disable the Suppress Zero Values and Suppress Missing options on the presentation tab and enable the Show All Values option for the dimensions.
Yes, we use above approach to reach my requirement. Thank you for your attention.
Would you mind marking this discussion as answered?
