4 Replies Latest reply: Dec 27, 2014 7:37 AM by Rakesh Pareek

# Rolling 12 months

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...

• ###### Re: Rolling 12 months

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:

Hope this helps you out,

regards Jakob

• ###### Re: Rolling 12 months

see the attached file

hope this helps

• ###### Re: Rolling 12 months

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

• ###### Re: Rolling 12 months

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

plz tell