Hi All,
I need to add a rolling 6 month revenue average, where in
its always looking at the last 6 months of revenue from the current month.
if current month is July , it should take an average of the 6 most recent complete months of revenue, which would be Jan,Feb, Mar, April,May,June.
Thanks in advance!!
Gops
To achieve rolling six month window you will first need to create a data item in your query using the date to parse month year combination.
If you don't have a data item with Month year combination, create a new data item in query to parse the date that will give you month year combination. Let's cal lit Month Year
ex: to_char([date], upper('mon - yyyy'))
Using the new data item, Month Year , create two filters in your query to look like this
[Month Year] > add_months ({sysdate}, -7)
[Month Year] <= add_months ({sysdate},-1)
Use this Month year data item in your table/chart display to show six months rolling window
-DRL
Hi ,
Thanks for the tip , I will try it and comeback!!
Regards
Gops
Are you using a dimensional or relational source?