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
Asset Risk
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.
Client Risk High Medium Low
Asset Risk
High 0 6 4
Medium 0 7 2
Low 0 8 7
Is there any approach to solve above problem?
