Level aware sum / sumOver problem

Hi there,

I am trying to use a custom field with sumOver() formula in aggregation for pie chart, but the aggregation is incorrect.

custom_total formula


It shows the correct number in the pivot table, but not in the pie chart when using the sum of {sumover} field.

not sure what and how QS came up with these numbers. Any suggestion on how I can solve the problem?