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?
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.
Hi @01267ts
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @01267ts
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!