Sorting

[Former Member]

I have a query in a workbook and want to sort this by one of the column values can this be done? If so is this at the query level or workbook and how? Thanks

[edwin_harpino · Accepted solution]

hi Niten,

yes, this can be done.

you can right click the column after query executed, in excel sheet, and choose 'sort' ->ascending/descending.

save the query as query view -> click bex button save -> save view global.

hope this helps.

[Former Member · Accepted solution]

Hi,

If you want to do sorting defionation in the query itself, you have to depend up on "Condition" concept. Give a condition "Top N" or "Bottom N" eq to 999999999999(some very large number) on that characterstic.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Thanks for that, I tried that and it does not work. I need to save the sort so that if I open the query again or someone else opens it shows the most frequently used at the top. Steps that I took was:

1) Sorted column ascending

2) Click on Save view global option

3) Gave the query view a name and title (random)

4) Refreshed query

5) Result was not in ascending order

[Former Member · Accepted solution]

Thanks guys first suggestion did work as well I needed to come out and log on again