# Total does not work as expected

**URL:** <https://community.amazonquick.com/t/total-does-not-work-as-expected/38685>\
**Category:** Q&A\
**Tags:** pivot-table, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 19, 2024, 8:58pm UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685 "2024-11-19T20:58:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![yuchen1](https://avatars.discourse-cdn.com/v4/letter/y/b9bd4f/32.png) [@yuchen1](https://community.amazonquick.com/u/yuchen1)\
**Post date:** [November 19, 2024, 8:58pm UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/1 "2024-11-19T20:58:49Z")

</div>

Hi,

My total on Pivot table does not work as I expect, I have value for some months. I would expect when it collapses, it will add up all the existing value. but when I collapse the columns, it shows 0. Does anyone know why this happens and how to fix it?  
Expand view:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/1/91933994c58b65e36605e7488b8bb50dd3a9dd54.png)  
Collapse View:  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/5/951dd737edf9302f96bfdeb78c2ca4343798571f.png)

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [November 20, 2024, 5:14am UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/2 "2024-11-20T05:14:22Z")

</div>

Hi @yuchen1

Can you check what is specified in the Totals? If it is default it should have summed up the values.  
![image|548x500](upload://qCsQ5XHJ5fJIpSEzg7Is99knJhU.png

Additionally, you can check the following to see how the calculations are being applied on the Pivot table.

> **[Adding and deleting pivot table calculations - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/adding-a-calculation.html)**
>
> Add or delete a pivot table calculation in Amazon QuickSight.

---

<div class="post-metadata">

**Author:** ![yuchen1](https://avatars.discourse-cdn.com/v4/letter/y/b9bd4f/32.png) [@yuchen1](https://community.amazonquick.com/u/yuchen1)\
**Post date:** [November 22, 2024, 6:34pm UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/3 "2024-11-22T18:34:40Z")

</div>

Thanks for replying to me Prabhu! I could not find specific calculation for totals.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/d/f/dfc2e5b6e620f6b8fce3bda9f7dd2228188930e2.png)  
Also, the value column is in custom because it is a calculated field, and there is no way for me to change it from custom to sum  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/7/3/73ba42492ceb86e3be2e1c000b9742c98c2bdfa0.png)

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [November 26, 2024, 11:26am UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/4 "2024-11-26T11:26:59Z")

</div>

Can you share your calculated fields formula?

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [December 3, 2024, 6:06am UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/5 "2024-12-03T06:06:12Z")

</div>

Hi @yuchen1

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [December 7, 2024, 9:41am UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/6 "2024-12-07T09:41:30Z")

</div>

Hi @yuchen1

Since we have not heard back from you, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [December 7, 2024, 9:41am UTC](https://community.amazonquick.com/t/total-does-not-work-as-expected/38685/7 "2024-12-07T09:41:34Z")

</div>

Archived on December 7, 2024, 9:41am UTC


