Add totals to table visual but only for certain columns

Question

I have tabular data containing the following columns:

Furnace | Burner Failures | Gas Consumed | Avg. Temperature |

I was able to add a row for totals by using the format visual option and then choosing add Totals, however, totals for all three row were added. Is there a way to only add totals to the Burner Failure Column and Gas Consumed?

Answer

Hello,

Regarding your query, please note that the totals row from the format option gives the total count for the columns in the 'values' section from the field wells. In case, if it is feasible for you, you can remove the columns that you do not need the total count for and add them to the 'group by' column similar to the below.

[https://docs.aws.amazon.com/quicksight/latest/user/adding-or-removing-a-field.html#add-a-field-field-well]()

![sample](/media/postImages/original/IM5C_IeypQQUmmywb9C67gXg)

Add totals to table visual but only for certain columns

Relevant content