Displaying 12 weeks as rows
Hi,
I have to develop a Webi report (3.1) in which I need to calculate sales for 6 weeks like this
Date Range Sales
Dec 28,2015 - Jan 3,2016 23,000
Jan 4 ,2016 - Jan 10, 2016 16,000
Jan 11,2016 - Jan 17,2016 7,000
Jan 18,2016 - Jan 24,2016 25,000
Jan 25,2016 - Jan 31,2016 14,000
Feb 1,2016 - Feb 7,2016 8,000
The dates above are fixed , regardless of the date on which report is run. i.e whenever the report is run, the dates will be the same as above.
Please help me to write the formula. Thanks.
Any help will be highly appreciated.
-
Interview Candidate
- Dec 30th, 2016
- 2
- 5538
Showing Answers 1 - 2 of 2 Answers
Related Answered Questions
Related Open Questions
Displaying 12 weeks as rows
I have to develop a Webi report (3.1) in which I need to calculate sales for 6 weeks like this
Date Range Sales
Dec 28,2015 - Jan 3,2016 23,000
Jan 4 ,2016 - Jan 10, 2016 16,000
Jan 11,2016 - Jan 17,2016 7,000
Jan 18,2016 - Jan 24,2016 25,000
Jan 25,2016 - Jan 31,2016 14,000
Feb 1,2016 - Feb 7,2016 8,000
The dates above are fixed , regardless of the date on which report is run. i.e whenever the report is run, the dates will be the same as above.
Please help me to write the formula. Thanks.
Any help will be highly appreciated.
Related Answered Questions
Related Open Questions