How to show missing dimension in pivot table

alex_stone — Wed, 23 Dec 2015 06:38:59 GMT

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?

Re: How to show missing dimension in pivot table

Gysbert_Wassenaar — Wed, 23 Dec 2015 17:46:01 GMT

Disable the Suppress Zero Values and Suppress Missing options on the presentation tab and enable the Show All Values option for the dimensions.

alex_stone — Mon, 01 Feb 2016 15:26:42 GMT

Yes, we use above approach to reach my requirement. Thank you for your attention.

Gysbert_Wassenaar — Mon, 01 Feb 2016 17:36:04 GMT

Would you mind marking this discussion as answered?