Displaying identical column in Straight Table

[#1]

Dear QV Experts,

One straight table, CustomerName, ItemNumber are dimensions.

                            Sum(Sales) is Expression.

I have two rows,

CustomerName     ItemNumber     Sum(Sales)

ABC                         1234               1000

BCD                         1234               2000

But it is displaying as

ItemNumber     Sum(Sales)

1234               1000

1234               2000

Though it is different customers but i am not displaying customers can we able to show the Identical Numbers in one row

ItemNumber     Sum(Sales)

1234               3000

The qvw attached.

Please suggest me.

Thanks in Advance

[#2]

Hi Sunny,

It works for me now. Awesome. Thanks a lot.

[sunny_talwar]