# Percentage in matrix

**URL:** <https://community.amazonquick.com/t/percentage-in-matrix/19725>\
**Category:** Q&A\
**Tags:** Business-Intelligence-Engineer, quick-sight\
**Created:** [October 16, 2023, 6:47pm UTC](https://community.amazonquick.com/t/percentage-in-matrix/19725 "2023-10-16T18:47:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KLIKIN](https://avatars.discourse-cdn.com/v4/letter/k/9fc348/32.png) [@KLIKIN](https://community.amazonquick.com/u/KLIKIN)\
**Post date:** [October 16, 2023, 6:47pm UTC](https://community.amazonquick.com/t/percentage-in-matrix/19725/1 "2023-10-16T18:47:48Z")

</div>

Hi All,

I have a dataset with the following fields: customerId, LastPaymentDate, SignedUpDate and TotalAmount.

I built a matrix where LastPaymentdate is in Rows, SignedUpDate in Columns and Sum(TotalAmount) in Values. The matrix works perfectly, but now I’d like to rebuild it with the percentages, the TotalAmount segmented in rows and columns divided by TotalAmount as you can see in the screenshot.

 ![screenshot](https://d1wl4jav5dp96l.cloudfront.net/original/2X/e/e66bcee953d6e196147f1c2f9f7f9d21f0022290.png)

Is that possible?

Thanks

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [October 17, 2023, 7:48am UTC](https://community.amazonquick.com/t/percentage-in-matrix/19725/2 "2023-10-17T07:48:16Z")

</div>

Hi @KLIKIN ,

did you check:

> **[percentOfTotal - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/percentOfTotal-function.html)**
>
> The percentOfTotal function calculates the percentage a measure contributes to the total, based on the dimensions specified.

BG

---

<div class="post-metadata">

**Author:** ![KLIKIN](https://avatars.discourse-cdn.com/v4/letter/k/9fc348/32.png) [@KLIKIN](https://community.amazonquick.com/u/KLIKIN)\
**Post date:** [October 17, 2023, 1:27pm UTC](https://community.amazonquick.com/t/percentage-in-matrix/19725/3 "2023-10-17T13:27:51Z")

</div>

Thanks it’s just the formula that I’m looking for