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

Column header sorting in cross tab

Hi
Can anyone please let me know as in how to sort column headers of a Cross Tab webi(customize order)?


I have a same requirement

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 02:17 PM

    Sourav,

    You will have to create one variable each based on your custom sort logic and build your cross tab data fields as well as the header fields based on these variable..

    For example suppose if have a custom sorting of cross tab with data as months

    then you will created 12 header variable and 12 data variable like below

    header1 = if [Month Number]=month(currentdate) then [Month Name]

    header2 = if [Month Number]=month(currentdate) - 1 then [Month Name]

    Data1 = if [Month Number]=month(currentdate) then [Revenue]

    Data2 = if [Month Number]=month(currentdate)-1 then [Revenue]


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 05:26 PM

    Click on one of the column headers, click on the sort icon and choose the type of sort you want.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22, 2014 at 06:00 PM

    How does the crosstab look like? Is it a special one. If it is an ordinary one, there will be no difference wether it you have vertical table or a cross tab -> just sort, like Mark already said.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 07:05 PM

    Hi Saurav,

    To use the custom sort, right click on your crosstab header and select "manage sort" from the sort section.

    Then click "add", select the dimension you would like to sort and click "values" under custom sort.

    You will then be able to sort the values from your dimension as you want them to appear in your crosstabb.

    Good luck,

    Stephanie


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Create The Variable(Dimension) Like

      =If [Dim]="Col A" Then 1

      Else If [Dim]="Col B" Then 2.....

      You can use "=" or Match() function here if values are different from each other

      Now Addthis Variable Above Your Crosstab column.

      By this way It will be easy for you to maintain your sort by formula

      Since it is in Column I am Expecting it to be 20-30 values for that object.

  • Posted on Jan 22, 2014 at 04:31 PM

    Please refer the below link.. it might be helpful.

    http://blog.davidg.com.au/2011/03/sorting-months-in-webi.html

    Thanks,

    Bala

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 07:27 AM

    Hi Saurav,

    If you are going to use that variable in more places then you do the order by in Universe level else do the custom sort in the web intelligence.

    Regards,

    Ragoth.C

    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.