How to get subtotal of a calculated field?

Hi QS users,

I am working on this pivot table view where YTD goal & 2022 goal are calculated fields. Is it possible for the subtotal row to reflect sum() instead of performing calculation? Appreciate any input/feedback on this! Thanks!

answered here Duplicated Data in QS Left Join