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

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])

correct calculation at totals level

It looks like you are partitioning by Clinic but not by Day Week Start.

Does adding {Day Week Start} to the partitions work? Or does taking out the partition by Clinic work?

Hi, @joe. Did the response from @Max answer your question? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!