Max Revenue from last three months Measure

Question

Hi All,

I want to create report with bleow columns

Month,   Revneu,  Max Revenue from Last three months.

Now i want to crate a mesure which shows max revenue from last threemonts.

please help me.

Thanks in Advance

1008490 · Answer

Thanks For your reply. How can I pass Last three months value.

Can you guide me in details.

Thanks in Adavance

Satya Ranki Reddy · Answer

Hi,

Follow below link you will get what your looking.

http://obieeil.blogspot.in/2013/08/obiee-and-time-series-calculations-in.html

Thanks,

Satya Ranki Reddy

AkanshAgarwal · Answer

Use Filter as

FILTER(Revenue USING Last Three Months)

and give the aggregation as Max.

Regards,

akansh