Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total

B

brettmanning24

Hello,

Hope whoever is reading this is well and can help! I have been looking online for a solution but as yet I cannot find any information.

In a pivot table if I hide / filter an item, I would still like to include this item in the subtotal / total. As soon as I hide / filer the value it is removed from the total. The item I need to hide I do not want the user to see but it is required in the calculation for the total.

Any idea's?

Thanks,
Brett
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - 2
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Pivot Table Subtotals 1
Show only Grand total in Pivot Table 0
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
pivot table excel 2
Pivot Tables (% to total within groups) 0

Top