Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try sorting by this expression: BUSINESS_PLAN.REQUIRED_DATE_YEAR*100+BUSINESS_PLAN.REQUIRED_DATE_WEEK
Try sorting by this expression: BUSINESS_PLAN.REQUIRED_DATE_YEAR*100+BUSINESS_PLAN.REQUIRED_DATE_WEEK
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
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
Thanks for your help it works