Processing table.

[#1]

Hello.

I have table

Number Type Date Sum
122 N 17.aug 6
123 N 18.aug 8
124 N 19.aug 5
123 A 20.aug 10


if it is two rows with same "Number" and Type of one row is "N" and Type of second row is "A"
i need make one row with Sum = Sum1+Sum2 Date =Date2 Type="N"

Number Type Date Sum
122 N 17.aug 6

124 N 19.aug 5
123 N 20.aug 18

I will be happy if somebody can help me.[;)]

[#2 · Accepted solution]

Hi,

This can be done by grouping the records..have a look at the attached qvw file.

Thanks

Amit