Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was trying to get the data for previous week and previous months ,below are the conditions what I want to achieve.
1)Prior Wk--Always should be sum of previous week data(example:present week is 31st so we need to do sum of 30th week data)
2)Prior Month-Always should be sum of 4 previous weeks data (means sum of 27th week to 30th data)
3)Prior 3 Month-Always should be sum of 12 previous weeks data (means sum of 19th week to 30th data)
4)Prior 12 Month-Always should be sum of previous 12 months data(means sum of last year from 34th week to present year 30th week data)
based on FISCAL_YEAR_WEEK_NUM field we need to get the Week Numbers.
thanks in advance
Hi.
You can use set analysis for periods.
Calculating rolling n-period totals, averages or other aggregations
And WeekNum function to calculate # of week.
Looks I have issue in data model..Can any one suggest me where went wrong.
Thanks
SwathiRaj