I tried with sample data it is working. Instead of Straight table you can using pivot table also. Here i'm attaching sample qvw file please check it.
TEST Working.qvw 153.8 K
Thanx for the quick reply.
But it's a bit different what I really wanna do becuz of my explanation is bad.
Please see the below.
The 3rd column enclosed with red line is project.
The 6th column also enclosed with red line is amount.
Project #0023395 is liked to 2 orders because there are 2 rows.
I'd like to merge those 2 rows into 1 row and show total amount by project there with setting some expression in dimension panel of the chart property dialog. (see the below)