Pivot Table unable to Include Hidden Items In Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a pivot table that lists only the Top 10 values in a column,
but also want the subtotal for the entire column, including the hidden items.
Excel Help tells me that I can click the "Include Hidden Items in Totals"
button, but the button is not available. I followed the help instructions to
first select "Subtotal Hidden Page Items" then to unselect it and didn't get
my result in either case. Any ideas on why the button is not available?
 
AFAIK, that button is only available if your using an OLAP cube as the
source data.

For other sources, you can include hidden page items:

Right-click on the pivot table.
Choose Table Options
Add a check mark to 'Subtotal hidden page items'
Click OK
 
You must log in or register to reply here.

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

Subtotal To Include Item Description On Subtotal Line 2
Conditional SUBTOTAL in XL210 Table 7
Pivot Table Subtotals 1
multiple subtotals in pivot table 1
Pivot table subtotals 2
Filtering within Pivot Table 1
How do I sort pivot table data by subtotals? 2
can i add subtotals to subtotals in a pivot table? 1

Back
Top