Sorting order Problem

[Anonymous]

Hello all!

I have a problem in the sorting order. I am trying to sort the sales of my qv report fron the highest value to the lowest, fisrt by store, then by floor no, but at the end the the sales are sorted and by Vendor but i dont want that to happen! I am attaching the qv file

Thank you very much in advance!!

[engishfaque]

Dear Kyparisia,

Please note, the priority of the Sales is less than other columns and if I am not mistaken and converted your UI sorted order in proper form then the script look like given below,

Temp:

LOAD Store,

     [Floor No],

     Floor,

     Vendor,

     Brand,

     Sales

FROM

Data File.xls

(biff, embedded labels, table is [Sheet1$]);

NoConcatenate

[Sorted Table]:

LOAD

  *

Resident Temp

Order By Store asc, [Floor No] asc, Floor asc, Sales desc;

DROP Table Temp;

Kind regards,

Ishfaque Ahmed