need help in pivot table

Tue, 17 May 2011 12:37:25 GMT

Hello,i need some help, i have table from production like this:

Order No, Step No, Machine Name, Qty Out

001, 00, A, 100

001, 01, B, 80

001, 02, C, 60

002, 00, A, 200

002, 01, B, 150

002, 10, C, 120

I need:

001, 01, B, 80, 100 (from prev step)

001, 02, C, 60, 80 (from prev step)

002, 01, B, 150, 200 (from prev step)

002, 10, C, 120,150 (from prev step)

Any sugestion how to make it in QV? I can make it in SQL - but prefer QV.

Thanks in advance

Re: need help in pivot table

Tue, 17 May 2011 13:00:45 GMT

Mimarcin, Have look at the attched application.

Hope this helps you.

- Sridhar

Tue, 17 May 2011 13:10:33 GMT

You are great