Pivot Table - Totals on calculated field working, but not on subtotals

[joe]

I have a pivot table with a % difference calculated field that aggregates and calculates correctly in they Totals portions of pivot table, but at the sub-total level it is inaccurate.

Rows are district (subtotal) and clinic (lowest level)
Column is Day of Week Starting

Calc field in question: percentDifference(sum( FTs ),[{Day Week Start} ASC],-1,[Clinic])

[joe]

correct calculation at totals level

[wwwyyy]

Hi Joe, thanks for reporting this issue. We will need more information to dive deep into the actual problem and identify solution. Please contact us via quicksight-help@amazon.com so that we can work with you on this more directly.