Rolling 12 months

[#1]

i have to show 12 rolling months actual cost and my dimension are 3 or 4 like job month den what to do and all these i want to present in bar chart nd in pivot table den plz help me...

[jjfabian]

Hi Sanya,

the SAP Sales Distribution Demo has a rolling Average has a rolling average in it (Billing Trends Tab, Rolling 3 6 12 Chart). The used formula is: 

rangeavg(above(Sum([Billing Sales Amount_NETWR]),0,12))

You can look it up here if you want to see it for yourself here:

http://eu.demo.qlik.com/detail.aspx?appName=SAP-Sales%20Distribution.QVW

Hope this helps you out,

regards Jakob

[SunilChauhan]

see the attached file

hope this helps

[#4]

Hi, i know you post is old, but can you explain what fields are the ones you use.

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1),  'MMM-YY'))"} >} Sales)

YearMonth

Date

Sales

[#5]

But what is the mean of this ?????

plz tell