I've created a Pivot Table that brings data from another worksheet in the same file as Pivot Table.
So I choose to hide some lines of my worksheet, but the Pivot Table toolbar button "Include hidden items in Totals" stays disabled.
Isn't this the exact function of this button?
Bookmarks