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
Solved! Go to Solution.
@MikeFrancis1959 One way of doing this
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.
k you both, both solutions will work for me!!!!
Mike