Pivot table shrinkage issue

[arpitkharkia]

Hi all,

My original pivot table looks like this:

But after certain selections it shrinks to:

How to keep the table intact in its position?

PS- Bot the dimensions are calculate dimensions.

I know values are not present for other buckets thats why its shrinking but is it posible to show '0' or '-' for them and maintain a consistent look for the table?

Thanks in advance!

[pradosh_thakur]

without looking at the data it is hard to tell but

can you try and see if it works for you

in the presentation tab

1: un-check  suppress zero value/missing value

2: change null symbols to '-' or '0'

regards

Pradosh

[arpitkharkia]

Hi Pradosh,

Yeah i know its difficult without data but i cant copy any data outside the the server. I tried those things in the presentation tab but no luck. Thanks for the help anyway!

[prat1507 · Accepted solution]

Hi Arpit

Go into your dimension and change the background color to the only({1}white())

This will retain all your dimensions irrespective of any selections.

Regards
Pratyush

[krishnacbe]

Select "Show All Values" in both of your dimensions.

[Gopi_E]

Hi Arpit,

You can use below expression in dimension background, it will resolve your problem.

Only({1}White())

In pivote table dimentions background it will fill with color if there is no value for perticular fileds

Regards,

Gopi