Values are not matching in straight table

[Anonymous]

hello,

I have the below data in separate straight tables for AA, BB and CC analysis for 2014

I have to get an aggregated chart to represent the totals of all 3 in total sales and individual sales for AA,BB and CC for respective destinations for 2014.

The Individual totals from the aggregated table for AA,BB and CC are not matching with the Individual tables.

I performed joins and got all the data into one single aggregated qvd and pulling that data in to reports and the numbers don't match.

Attached is my QVW.

Can someone please help me with this.

Thanks!

[Anonymous]

when i make any changes i see this issue...

Attached qvw in the initial post, can someone please help me with this asap...

Thanks!

[Anonymous]

I tried group by on joining tables and it worked!!

Thank you all for your time!