# How to display both % values and absolute values under the same column value

**URL:** <https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981>\
**Category:** Q&A\
**Tags:** analysis, calculations, formatting, quick-sight\
**Created:** [March 11, 2023, 5:52pm UTC](https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981 "2023-03-11T17:52:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aditya\_Raj](https://avatars.discourse-cdn.com/v4/letter/a/b77776/32.png) [@Aditya\_Raj](https://community.amazonquick.com/u/Aditya_Raj)\
**Post date:** [March 11, 2023, 5:52pm UTC](https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981/1 "2023-03-11T17:52:07Z")

</div>

Hi  
how to display both % values and absolute values under the same column value, refer the below image

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

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [March 12, 2023, 2:51pm UTC](https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981/2 "2023-03-12T14:51:41Z")

</div>

You can create a calculated field for percentage and use both count and calculated field in pivot table to achieve this. Please have a look on the [Build Your First Dashboard with Amazon QuickSight](https://community.amazonquick.com/t/build-your-first-dashboard-with-amazon-quicksight/7227) and one of the scenario is having both count and percentage.

Regards - San

---

<div class="post-metadata">

**Author:** ![abacon](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/abacon/32/2291_2.png) [@abacon](https://community.amazonquick.com/u/abacon)\
**Post date:** [March 16, 2023, 1:57pm UTC](https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981/3 "2023-03-16T13:57:27Z")

</div>

Hi @Aditya_Raj,  
We hope the reply from @Sanjeeb2022 worked for you.  
Let us know if this is resolved. And if it is, please help the community by marking the reply as a “Solution.”  
Many Thanks,  
Andrew

---

<div class="post-metadata">

**Author:** ![apjvinod](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@apjvinod](https://community.amazonquick.com/u/apjvinod)\
**Post date:** [March 22, 2023, 7:24am UTC](https://community.amazonquick.com/t/how-to-display-both-values-and-absolute-values-under-the-same-column-value/10981/4 "2023-03-22T07:24:51Z")

</div>

Hi @Aditya_Raj

Hope you are able to resolve this issue . Since we have not received a response from you on this question, we are going to archive the question.

If you still need support on this issue, please create a new question topic. Thanks for posting your questions on the Quick Sight Community Q&A Forum!