Pivot table

[#1]

HI everybody!

I began working with QV not long ago and have a question,

How to transform the followinf table:

Start	Transit	End	sum(Weight)
A	B	C	10
A	B	D	20
A	B	E	5
A	B	F	30
A	B	G	5
H	I	J	10
H	I	K	10

into;

Start	Transit	End	sum(Weight)
A	B	C	70
A	B	D	70
A	B	E	70
A	B	F	70
A	B	G	70
H	I	J	20
H	I	K	20

I need to group the column with the result by "Transit" field but keeping the "End" column.

Is it possible to do in the diagram expressions?

[#2 · Accepted solution]

Please try this in your expression

Sum(TOTAL<Start,Transit> Weight)

[#3]

Nhu Ngo, thanks a lot, it works!