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

sumOver(total,[{event_date},{channel_id},{rule_name},{shared_with}],PRE_AGG)

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?