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.

Showing Answers 1 - 4 of 4 Answers


  • Feb 2nd, 2017

If you have access to write Custom Query in the Report, it will be easy. I am not sure about report level.

  Was this answer useful?  Yes

Sanjay Mohan

  • Jun 15th, 2017

1. Could you please share me the Quantifiable measure used within?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions