Max Revenue from last three months Measure

1008490

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

Gianni Ceresa

Sorry but ...

How is that different from Creating a Measure: Max Sale Amount from Last Three Months ?

What's the point in answering your threads if you just open a new one?

Please avoid double posting, it makes the forums unusable (just think if everybody post their questions 2-3 times).

AkanshAgarwal

Use Filter as

FILTER(Revenue USING Last Three Months)

and give the aggregation as Max.

Regards,

akansh

Satya Ranki Reddy

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

1008490

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

Can you guide me in details.

Thanks in Adavance