Skip to Content
author's profile photo Former Member
Former Member

Sort of Spreadsheet table data

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 04:25 AM

    Thanks All for the help. I have added a column for sorting using custom sort order that was required in Universe and that solved my issue.

    Thnx again

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 11:45 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 05:04 PM

    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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 10:14 AM

    Did you try "sort" option under "data" tab?

    when you click on sort dialog box appears. it ask you on which column you want sort.

    Try this.

    Hope you get your expected result.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.