Skip to Content
0
Former Member
Jan 19, 2009 at 02:47 PM

Get rolling 12 months for a variable number of months

1052 Views

Hi Forum,

There's the following problem I hope to get solved with you:

The users can define a range of an 0calmonth (referenced).

So, each month in this range is provided in columns, one keyfigure is selected in rows.

The result should be an average value of the last 12 months for each month.

We had to do the same for just one year, so we could use static selections.

But is there a way to do this dynamically?

I'm looking forward for any idea.

Many thanks in advance,

Tobias