Incorrect Partial Sum in Pivot Table

[fungcheung]

We design to create a pivot table with total at the bottom, however, the total is incorrect. Is there any suggestion on the expression with correct data displayed?

Actual Result:

Expected Result:

  

[Brett_Bleess]

Chun Fung, did Florentina's post give you what you needed?  If so, please be sure to give them credit by using the Accept as Solution button to mark the post as the solution.  If you did something else, consider posting that and marking it.  

I have one Help link that may shed some further light upon things for you, so you understand what is likely going on behind the scenes on this one:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Hopefully this may be helpful.

Regards,
Brett