GetPivotData for colums not shown

[TDC21]

Hello all,

I have a pivot table but for formatting reasons I would prefer to show the grand total as a cell reference, not as an additional column in the pivot table. I have the formula = GETPIVOTDATA("[Measures].[Sum of SVC_COST]",$B$3) but as soon as I remove the grand totals from the table the formula results in an error.

Is there a way to alter the formula or to create a measure that can be used in a cell?

Thanks