Last 2 Years ascending

[blaise]

Hello guys

In a dashboard graph i need to show figures for the last two years (within the selection) ascending, meaning for today() the graph will show 2008 and 2009 (in that order).

With a sort by ascending on the Year I can achieve this on a 2 year selection, but of course not with no selection at all (as it will show the last 2 years).

Is there any way so solve this?

Im running 8.5

[#2]

Hi,

see the attached example for help.

Play with the "Set Analysis" expression and see the results.

Another example are this one (three month period):

Sum ( {< OrderDate={">=$(=addmonths(monthstart(max(OrderDate)),-2)) <=$(=addmonths(monthend(max(OrderDate)),0))"}>} Amount)

Good luck!

Rainer