I am reading values from a Universe and inserting into excelsheet. This query is reads date as input through calendar.
This will always result in 5 rows and with 10 columns. The first column will be of Type which non-numeric.
I have to sort entire result set based on first column.
Any idea how to do this. I tried sorting using excel data sort, but no effect.
I have gone thru this thread but no help
Thx
Hi Charlie,
As you have mentioned above, you will be getting only 5 rows in your result output. So you should write the excel ranking function RANK() in a new column to sort the entire 1st column of your data.
This column gets the rank of each row data in 1st column i.e.,1,2,3,4,5 values.
Then use the appropriate VLOOKUP() or HLOOKUP() functions to get the complete 10 columns of the data in ascending order of the ranks.
Map this final data to the spreadsheet which is sorted.
Hope this fulfills your requirement.
Hi Charlie
http://scn.sap.com/thread/3471357
Please see the above thread and check the file I have uploaded Scorecar_Sorting - Copy.zip.txt.zip
This is how you can sort data within spreadsheet.
However, it is always recommended that you sort your data before getting the data to and if you are using Query Browser, query definition is the best place to sort. Since thats not working for you, try the above.
Thanks
Runali
Add a comment