Sorting problem

[_jl_]

Hi all,

See attachment.
2013/05/20 is Data Item for Last Week
2013/05/27 is Data Item for Current Week

The problem is I would like to have those figures sorted from highest to lowest based on "Current Week". At the moment sorting is based on "Last Week". I can do it by changing the order of these Data Items in the chart but I want to display these figures so that last week is on left and current week is on right. So that wont help me because then display order of the weeks gets changed too. :)

So basically what do I have to do in order to display figures exactly in that kind of form, but from highest to lowest, based on current week.

Thank You!

[_jl_]

Doesn't anyone know? :o Here's another picture if it helps understanding what is the problem. So when I click on "Category Name" -> Sorting-> Define sorting based on "Measure", it sorts the data based on Last Week, which is first on the series. ->> But I need to sort the data based on Current Week which is second on the series.

[RKMI]

Hi JL,

Just use a condition block and two charts one for current week as the driver other change the sequence for last week. Than based on the Current or last week selection the correct chart would appear.

I know there is a drawback to this method depending on how many type of display you have. You will need to create the chart for current week, last week, current month, last month and so on. But, this senario is more trick since it looks like you are pulling the set directly and dynamic conditional based formatting in one chart since you would need to write a similar type of case statement which is why I would recommend the use of conditional block/ variables for display.

Thanks,
RK

[_jl_]

Sorry but I didn't understand how to do that... Any examples on that...?