Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a requirement like need to capture data based on 2-week range dimension.
For Eg:
Period Data
2/15/2014 - 3/1/2014 3
3/2/2014 - 3/16/2014 15
3/17/2014 - 3/31/2014 20
4/1/2014 - 4/15/2014 6
4/16/2014 - 4/30/2014 10
I am using WeekEnd_date dimension. How to capture 2 weeks data and it should not be rollingsum.