I am using a top row to add the totals for certain items. Right now I'm using a simple reference =L28, which is the Expense Total that equals ($298) The problem is that when I want to remove Transport, the cell location changes.

I'm trying to use GETPIVOTDATA to extract that but I keep on getting errors on the formula. The Pivot table is called PTProfitLoss.

I've tried variations of =GETPIVOTDATA("Actual",$A$3,"Category","Expense Total") that was generated by AI. However I keep getting errors.

Any suggestions.

Thanks