# Subtotals for waterfall charts **URL:** \ **Category:** Q&A\ **Tags:** error, developer, quick-sight\ **Created:** [September 4, 2024, 5:21pm UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674 "2024-09-04T17:21:19Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![patrickhoey](https://avatars.discourse-cdn.com/v4/letter/p/e95f7d/32.png) [@patrickhoey](https://community.amazonquick.com/u/patrickhoey)\ **Post date:** [September 4, 2024, 5:21pm UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/1 "2024-09-04T17:21:19Z")
I’m trying to replicate an Excel waterfall chart (see Screenshot 1) in Quick Sight. Specifically, I want to be able to designate certain fields as subtotals, like Net Sales and Gross Profit. Is there a way to do this? Thanks! Screenshot 1 ![Screenshot 2024-09-04 at 10.31.30 AM](https://d1wl4jav5dp96l.cloudfront.net/original/3X/e/c/ecd4efdd31d22da0b31743030ba02145b4906c6e.png) ---
**Author:** ![Nico](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/nico/32/32113_2.png) [@Nico](https://community.amazonquick.com/u/Nico)\ **Post date:** [September 6, 2024, 6:32am UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/2 "2024-09-06T06:32:00Z")
Hi @patrickhoey , welcome to the community 🎉 Have you seen this introduction? > **[Using waterfall charts - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/waterfall-chart.html)** > > Work with the waterfall visual type in Amazon QuickSight. You will need a datasource with one column that lists Discounts, Returns etc and on column that categorizes them into the subtotals. Best regards, Nico ---
**Author:** ![patrickhoey](https://avatars.discourse-cdn.com/v4/letter/p/e95f7d/32.png) [@patrickhoey](https://community.amazonquick.com/u/patrickhoey)\ **Post date:** [September 6, 2024, 3:11pm UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/3 "2024-09-06T15:11:12Z")
Hi @Nico, thanks for your response! If I set up my dataset so that one column listed Discounts, Returns, etc. and one column designated subtotals, how would I arrange these columns in the waterfall chart to get something like the screenshot I sent? What would go into the field wells: category, value, and breakdown? ---
**Author:** ![Nico](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/nico/32/32113_2.png) [@Nico](https://community.amazonquick.com/u/Nico)\ **Post date:** [September 9, 2024, 6:20am UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/4 "2024-09-09T06:20:16Z")
Hi @patrickhoey , your kpis (discounts, returns etc) should be in category, than the subtotals (Gross sales, net sales, gross profit, …) in the breakdown field to get the bars and then the value field in the value place. Best regards, Nico ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 23, 2024, 10:04pm UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/5 "2024-09-23T22:04:02Z")
Hi @patrickhoey, It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 26, 2024, 6:06pm UTC](https://community.amazonquick.com/t/subtotals-for-waterfall-charts/34674/6 "2024-09-26T18:06:21Z")
Hi @patrickhoey, Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed. Thank you!