Excel 2010 Pivot Table - calculations including hidden items

[excelwork123]

Goal

1. In a simple pivot table, I'd like to perform a calculation ( show values as ) in the pivot, that executes the calculation with all items, including hidden. I'm sure as everyone is aware, the clalcs are performed on visible objects only.

Details below. I don't want anyone to think that I haven't looked before posting.

• Working in Excel 2010
• Not using power pivot, just your everyday pivot
• Subtotal filtered page options, is unavailable ( grey ).
• Data source is from a none-table cell range.
• I know there are workarounds, I could calc in a separate range and display that, but I'm dying to know how to accomplish in a standard pivot.
• Sounds like powerpivot can accomplish, and that could be an option, but I'm trying not to install new software to other people.

My head is bruised an bumpy from this simply task. Thanks for taking the time to read.