Is anyone a Pivot Table Guru?
I need to use the GetPivotData formula to get a subtotal line within the
Pivot, but when I use the equals I keep getting a reference error!

eg. Need to access Sep Hrs - cannot get total as I receive a ref error.
But for Total hrs I can use the formula!!

Is there a way I can use the getpivotdata formula or another formula to
access these category subtotals from the pivot table!! The pivot table is
dynamic aswell, and its range grows as you add in additional weeks..

Help!!