Size of pivot table

[Anonymous]

Hi guys,

I have a pivot table with 2 dimension :Var1 and MYear.

When I select a couple months, my pivot table get shorter

Who knows a trick how to keep the same size of pivot table? (like it does a chart)

Thanks,

[cgdonders · Accepted solution]

Hi,

On tab 'Layout' deselect option 'Size to Data'.

[#3]

Hi attached is an example.

Properties > Layout > uncheck 'Size to Data'

Thanks

AJ