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

Question & Answer
1

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

Screen Shot 2022-04-28 at 11.04.09 AM
Screen Shot 2022-04-28 at 11.04.09 AM1778×206 11.5 KB

2

correct calculation at totals level

Screen Shot 2022-04-28 at 11.05.03 AM
Screen Shot 2022-04-28 at 11.05.03 AM1756×116 5.01 KB

4

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?

5

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!