Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i want one analysis in which for every current month value it should calculate back three month average.i.e
For Apr= (Jan+Feb+Mar)/3
For Mar = (jan2015+feb2015+dec2014)/3
for Feb = (jan2015+dec2014+nov2014)/3
please help me in that..
thanks
It depends on several things to approach. Where do you want this to be calculated, a textbox or chart? If chart, what would the there in the dimension? For generic, read :Calculating rolling n-period totals, averages or other aggregations
For specific help, try to create a sample qvw and share.
hi tressco,
i have to show it as a trend for month dimension in line chart.
thanks
Read the post by gwassenaar I suggested above. It explains the similar topic very nicely. Otherwise, a sample qvw could help me help you.
Hi,
As tresesco suggested if you attach a sample file with your expected output it would be easier to solve.
Calculating rolling n-period totals, averages or other aggregations
Regards,
Jagan.