How can I do this dynamic analysis ?

[krist]

Hi All,

I need Dynamic sales analysis layout like below, Is this possible ? or this is NOT what OLAP for ?
From month to month the layout should change.

In April :
Jan Feb Mar Avg_Last_3_Month Current
--- ---- --- ---------------- ----------
Product1
Product2
Product3

In May :
Feb Mar Apr Avg_Last_3_Month Current
--- ---- --- ---------------- ----------
Product1
Product2
Product3

Thanks a lot for your help,
Krist

 

[AMJackson]

This is certainly something you can use OLAP for.
The way I'd do this is to set up a "Named Set" on the server, or create a set from an expression in CA (using the member selector). Define the set to be the last 3 months, can't recall exactly how to but should be easy.
You can then create a calculation based on that named set.

 

[krist]

Hi AMJackson, Thanks for the reply.
What I need is : Not only the value, the column name should also be dynamic, i.e :
In April :
Column-1 = Jan
Column-2 = Feb
Column-3 = Mar
In May :
Column-1 = Feb
Column-2 = Mar
Column-3 = Apr

Do you think I can do this with "Named Set" or create a set in CA's member selector as you said.

Thanks again,
Krist