Problem with sort in a table

[#1]

Hello everybody,

I have a problem with sort  in a table. I want to sort a week as dimension in a table ascending. I sort about the fomula. The Problem is now that thef first week I want to see in the Table stand on a other position. What can I do? For example I attach a sample.

greetings Sven

[Gysbert_Wassenaar · Accepted solution]

Try sorting by this expression: BUSINESS_PLAN.REQUIRED_DATE_YEAR*100+BUSINESS_PLAN.REQUIRED_DATE_WEEK

[bbi_mba_76]

Hi,

this could work, in the calculated dimension:

=if(BUSINESS_PLAN.REQUIRED_DATE>=vStartBP  and

    BUSINESS_PLAN.REQUIRED_DATE<=vEndDateForecast2,dual('KW' & BUSINESS_PLAN.REQUIRED_DATE_WEEK,BUSINESS_PLAN.REQUIRED_DATE_WEEK))

    and then sort bereich by numeric

[#4]

The idea is good but the problem is the week 1 is the first week of 2014. So the week must follow the week 51.

Thanks for your help

[#5]

Thanks for your help it works