Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sreeharsha ,
See blog posts Relative Calendar Fields and Accumulative Sums and document Calculate rolling n-period totals.
You can use MonthYear function
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
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 !!
Not Working