Quicksight Totals Disappearing


I’m using pivot tables and it seems that when I add too many fields to the rows field well the row totals disappear. I have data broken down by week in the column field well. Once I hit 12 fields in the rows field well, the totals for an individual week disappear.

Is there a limit I’m not aware of or is this some bug? Any help would be appreciated

Hi there,
Totals and subtotals are blank for table calculations on metrics aggregated by distinct count, so you may want to double check that.
For reference, here I leave the link with the Pivot table limitations Pivot table limitations - Amazon QuickSight