# Showing global total and regional breakdown for a percentage calculated field

**URL:** <https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [May 23, 2022, 9:53am UTC](https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754 "2022-05-23T09:53:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sng](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@sng](https://community.amazonquick.com/u/sng)\
**Post date:** [May 23, 2022, 9:53am UTC](https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754/1 "2022-05-23T09:53:47Z")

</div>

Hi, besides Pivot Tables with total, is there any chart that can show both the global total and regional breakdown for a percentage? A stacked bar chart only shows the actual percentages summed up, example if region A is individually 10% (5/50) for calculated field XYZ, region B for the same field XYZ is individually 5% (5/100), it shows 15% as total, instead of 6.67% (which is the global percentage).

A donut chart almost works: it shows the total and the regional breakdown, but the regional % are then shown as numbers only if choosing the ‘show Values only’ data label option, with no way to format back to percentage (see image).

Is there any way to show the global total and region breakdown side by side?

 ![Screenshot 2022-05-23 at 5.52.39 PM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/4/4f8ad8ade0458493e310f3654fbe416a39c409d5.png)

---

<div class="post-metadata">

**Author:** ![DeepakS](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@DeepakS](https://community.amazonquick.com/u/DeepakS)\
**Post date:** [May 26, 2022, 10:00pm UTC](https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754/2 "2022-05-26T22:00:50Z")

</div>

Hi, as part of the data label formatting for donut chart, 3 options are available -value only, percent only, value and percent. Use the value and percent option to see both numbers and % of total.

You can also create a calculated field using function - [percentOfTotal - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/percentOfTotal-function.html)

---

<div class="post-metadata">

**Author:** ![sng](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@sng](https://community.amazonquick.com/u/sng)\
**Post date:** [May 27, 2022, 1:39am UTC](https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754/3 "2022-05-27T01:39:31Z")

</div>

Hi, thanks for the reply. However, I don’t want to see the percentOfTotal, each individual slice itself is it’s own % (calculated field) already. So I just want Value only, but it is a percentage calculated field (formatted also as a percentage) but shown as a decimal as in the original image.

Instead I would like 0.91 to be shown as 91%, 1 to be shown as 100% , etc.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [November 2, 2022, 6:31pm UTC](https://community.amazonquick.com/t/showing-global-total-and-regional-breakdown-for-a-percentage-calculated-field/3754/4 "2022-11-02T18:31:29Z")

</div>

Can you format the numbers as a percent?

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/54ff045e93884579180a98469c6e8cde37deebbe.png)

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/ba9ae98d05a8911456a01a9126f78aa717ce4803.png)

You can also pick percent only for the metric label.