Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table unable to Include Hidden Items In Subtotals
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have a Pivot Table Include a "% of an item" | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
How do I manipulate pivot table report to include percentage of? | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |