Aggregating a sum over two dimensions for a chart

[alespooletto]

In my table, I have the correct amounts of items ordered and quoted associated with different USERNAME (cancelled out field in red). 

Each of these users made one of these either orders or offers, and the numbers to the rigth in the two columns show the sum of items associated with those offer/orders. Now, in the chart, I want to display the same values, but not broken down by single order/offer number, instead I want it to be generic for all of the users. 

You can clearly see it doesn't work at the moment, since the number 1 has 40k items, when the real numbers show all of the users made < 70k. Can someone please help me out? The two fields are just calculated as Sum(Items_Ordered) + Sum(Items_Offered) as of now. 

Here is a sample of the data: 

USER1	422436722	84157737	62	74
USER2	422436722	84157737	62	74
USER3	420829135	82884584	55	22
USER4	420829135	82884584	55	22
USER2	420829135	82884584	55	22
USER5	420829135	82884584	55	22
USER3	420829135	82884584	55	22
USER3	421432294	83460793	53	55
USER1	420682572	82904020	46	0
USER1	421525688	83514189	46	78

[Bhushan_Mahajan]

@alespooletto Please provide sample data.

[alespooletto]

Hello, thanks and I added a sample

[Bhushan_Mahajan]

@alespooletto It is working in my case with provided data. Check below screenshot.

[alespooletto]

Huh, interesting. It doesn't work at all for me, gives me very high values like in the photo... I wonder if its a data model issue now