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,