Force to show all dimension values horizontally in Pivot Tables

[k_burata]

Hi All,

I have the types table below:

Types
CA
FT
PT
Unknown

and these pivot table:

When I select on Pos2, the column CA disappears since I don't have data for this.

How do I do it that even though a selection is made, It still shows all the types values. Can I do it on the chart or do I do it in the script?

Thanks

[agomes1971]

Hi,

please see the image below...

Check Show all values to type dimension.

HTH

André Gomes