GetPivot Function to get Sub Total

[PShingadia]

Hi All:

I have a formula:

=GETPIVOTDATA("[Measures].[Sum of Apr-19 2]",$D$15,"[TotalCombinedFTEByCheckType].[Check Type]","[TotalCombinedFTEByCheckType].[Check Type].&[High Risk Trader]")

- which gets the subtotal for column named High Risk Trader.

I need this to be dynamic and refer to a cell so that I can copy across to pick up subtotals from a range of columns. How to I amend this formula so the High Risk Trader refers to cell instead? Everything I have tried brings back a #REF error!

Prav