Table with only totals in quicksight

In quicksight I am trying to display the totals of some columns in a table without showing the records.

I have the following data

ID Price Discount Cost
1000 100 10 60
1001 200 20 120
1002 1000 100 600
1003 2000 200 1200

I want to create a table that shows:

Price Discount Cost
3300 330 1980

How can I can do that? I have tried with showing totals in tables but the detail rows keep showing in the table

Hello @Enrique_Martin - Please try to create 3 calculated fields respectively having expressions as sum(Price), sum(discount) and sum(cost) and use those fields instead of the original ones. Hope this helps!

image

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!