If I replace the above with a normal static column dimension then there is no automatic recalculation and no column resizing/jiggling.
In other cases there is automatic column resizing/jiggling occurs even when there isn't a dynamic dimension involved. In these cases it is usually when the pivot table grows quite wide due to dimensions' visibility being toggled through the use of the "Show column if" dimension property.
This occurs on both Chrome and Internet Explorer 11.
Has anyone else encountered something like this?
Maybe I should do a screen capture to better explain the behavior.
Re: Pivot table continually recalculates and resizes its columns
Hello, Do you have any sample file that I could import on my environment, to see the behavior of your pivot table? If possible please attach it here or send it to me via direct message so I can investigate further.
Thank you in advance.
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.