Need to show the data for past 12 months

[#1]

Hello Everyone,

Can any body help into this,

I need to create one chart,

Dimension is month,

Measure is Revenue,

My scenario is if i select 2014 i need to show 12 months data, means currently we are in September, i need to show the data from Sep to past 12 months( till last year oct-2013),

If i select 2013 it show 12 months of 2013 data

How to achieve this, can any body help into this,

Thanks in advance

[Siva_Sankar]

Sreeharsha ,

See blog posts Relative Calendar Fields and Accumulative Sums and document Calculate rolling n-period totals.

[ecolomer]

You can use MonthYear function

[#4]

Thanks for the sharing,

But for me both actions( current Year selection and PY selection) should happen in to the same chart

any other way to do this, please let me know

[#5]

Hi ,

Try Like this .

Expression

=sum({<trn_Date={'>=$(VarPrev12Maxdate)  <=$(VarMaxdate)'}>}  amount)

Variables

VarPrev12Maxdate : date(max(trn_Date),'DD-MM-YYYY')

VarMaxdate : Date(AddMonths(VarMaxdate,-12),'DD-MM-YYYY')

Thanks !!

[#6]

Not Working