Total does not work as expected

Question & Answer
,
1

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
image1307×481 16.8 KB

Collapse View:
image
image252×552 2.32 KB

2

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.

3

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

image
image276×551 6.79 KB

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

4

Can you share your calculated fields formula?

5

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!

6

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!