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