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,