All item total vs filtered single item total in bar chart

[Anonymous]

Hi I have a problem where the value shown when highlighted an item and showing all is different in the bar chart.

Once filtered, the value is correct

What's the issue. Ill upload the QVF file together !

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1), Sub_category, Currency))

[Anonymous]

this works, and solved