Forum Discussion

ericbi's avatar
ericbi
Frequent Visitor
8 years ago
Solved

How to sort weeknumber in row?

Hi,    I have table like this  I would like to have a visualization table like this and the top row sorted by weeknum descending. but BI always sort it ascending. I checked lot of topic but ...
Need Help
  • ericbi's avatar
    ericbi
    8 years ago

    I found that I can sort it in the report after I submitted to the web.  just go to that visualization at right corner and select sort by weeknumber then done.  it's not working in desktop. 

     

    thank you everyone. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Credits to @ipsingh79 in an earlier forum post. I checked his solution and that works:

 

Please check if all weeks are correctly filled like 201801, 201818, etc. This must be correct to let the solution work.

Open Edit Query --> Add custom column as : SortWeek = 999953 - [Week]

Apply and Close the query editor

Sort the original Week column with the custom column "SortWeek"

 

Matrix will be correctly sorted (201803 as first column)

ericbi's avatar
ericbi
Frequent Visitor
8 years ago

I found that I can sort it in the report after I submitted to the web.  just go to that visualization at right corner and select sort by weeknumber then done.  it's not working in desktop. 

 

thank you everyone.