I have a table that fills the cells with totals for each column/row pairing and I want to add columns that calculates the percent total for a given column. An example is attached below

Hi @dcoletta , QuickSight supports Percent of Total as Table Calculation for Pivot Tables. Please refer below link. Additionally you can also create a calculated field using Percent of Total function.

Regards,

Karthik

I know how to create a table where all cells use percent of total, but is there a way to have the totals and percent of totals in the same table?

@dcoletta are you looking for something like this? We have total sales for each segment, overall sales and also percent of sales for each segment. If this is not what you are looking for can you share an example (excel mock up) with clear column headers and highlighting what you need in the example.

Regards,

Karthik

Yes, that is what I was looking for. Thank you

Thanks for confirming @dcoletta!

Below is the screenshot of implementation. Hope this helps. Please mark as solved from your end.

Regards,

Karthik