Weeks asc wrong

[0li5a3a]

Hi all.

Could you please  hwlp me to sort the weeks problem?

I have something like this

The problem is... everything before 11 is 2017 data and all the rest are 2016 ... I used in the expression this  calculation =count({$<Status= {'WP'}, CalendarPeriodnum={'>= $(=num(WeekStart(AddWeeks(max(CalendarPeriod),-15)))) <= $(=num(WeekEnd(max(CalendarPeriod))))'},YrWeek=,CalendarYear=>}TICKETID) and I think.

Any advices ?

I want the maximum week - 16

[arvind_patil]

Hi Constantin,

Please provide sample data.

May be you need to sort in descending order.

Thanks,

Arvind Patil

[0li5a3a]

Hi Arvind,

I fixed my problem. Thanks your your message.

Regards,

C