Totals in Repeating Sections for PixelPerfect Reports

I need to get the total for each group in my PixelPefect Repeating Reports and I have no clue how to do this, when I turn on Totals, it gives me Totals for everything, not just the selected report. Anyone have any idea how to accomplish this? Basically, I have a list of projects and the projects are grouped, then I want the total for each project. I am using a table visual to make the groups in case that helps any.

Hello there,

I am looking into your query and will revert.

Regards,

Hello there,

QuickSight does not support subtotals in standard table visuals. You must switch to a pivot table visual type if you need to display subtotals for your grouped data.

Regards,

Ok, this is a major oversight that needs to be corrected as Pivot tables do not work for what I need to do. For now, I have just added a second table that does the trick, but it isn’t ideal.

Hello cmwade77,

Thanks for the feedback. I will flag this as a feature request for the QuickSight team.

Regards,