can anybody helpmeout in resolving this issue
I have a sample data as shown in figure which has two headers in the same source sheet as shown below
now i want the result in qlikview as below.. I want the last record to be updated for the time being and also let me know what i need to do if i would like to list all the records from 1 to 6 with the same order,target and delivery date populated in their corresponding columns instead of only the last record which is my current requirement now as displayed below in the image.
I thouth that a cross table can be used to get the above result ,im not sure ,kindly helpme out in getting this resolved.