I have the table below but I would like to be able to display subtotals for each IC on the team. I could not find a way to do that on a table. Any ideas?
Hi @deb21,
You should be able to get subtotals based on how you group or sort. In this instance, what is being referred to when discussing ‘IC’s’? If you would be able to build this out in Arena, I can take a look at what would be needed.
Thank you! I can’t due to sensitive data. The ICs is just names of people on the team that are conducting those activities so I was trying to get a subtotal for each of them. There’s no option for subtotal either in the field or the table properties only totals, unline the instructions provided here.
Hi @deb21 - You can show the total for table type visual and total and sub total for the pivot type visual. Please see the documentation below.
On tables and pivot tables, you can configure the display of totals or subtotals. Tables can display totals at the top or the bottom of the visual. Pivot tables can display totals and subtotals on rows and columns.
Regards - Sanjeeb
Did this solution work for you? 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!
Thanks Sanjeeb but there’s no option for subtotals only total. I tried to follow these instructions but there’s no Subtotal anywhere in the table properties.
Hi @deb21 - There is NO subtotal for table type visual. If you want sub total, you need to change the visual type to pivot.
Regards - Sanjeeb