Recalculation of values in pivot tables when columns are hidden

Q&A
,
1

Specifically for pivot tables:

If columns can be hidden (either manually or dynamically),
do the totals and subtotals displayed on the right side of the pivot table recalculate based only on the visible columns?
or do they still include values from hidden columns?

2

Hi @01267ts ,

It will not recalculate if you just hide the column. If you want the values to recalculate, then you may have to write calculations to exclude it.