Can I add columns in a table based on calculations?

Question & Answer
,
1

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
Picture1 (2)

2

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

3

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?

4

@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.
image

Regards,
Karthik

5

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

6

Thanks for confirming @dcoletta!
Below is the screenshot of implementation. Hope this helps. Please mark as solved from your end.

image
image1286×694 67 KB

Regards,
Karthik