Trying to get Crosstab to present the data they way I need!

[MikeFrancis1959]

I have attached a excel file and on sheet1 it shows sales orders and the qty per order. I am comparing yesterdays data to todays to see if any qty's have changed. I have the data segregated by previous & current along with the qty. I want to create a pivot similar to what I  have in Excel with the sales order number in the row, Previous & Current in columns and the qty so I can see if any changes occur. I have tried crosstab a few ways but could not get it to show like Excel. I think this is simple but not sure what is the easiest way to accomplish this, can someone help me out?

Thanks,

Mike

[binuacs · Accepted solution]

@MikeFrancis1959 One way of doing this

[Peachyco]

Another approach is to combine the [Current] and the [Previous] columns into one column, and use that as the headers in the Cross Tab tool.

 

 

[MikeFrancis1959]

k you both, both solutions will work for me!!!!

Mike