Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
see the attached file
hope this helps
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
But what is the mean of this ?????
plz tell