i need to create new sales analysis report
select a date - select a currency then
give me 4 column (last day sales - last week sales - last 2 weeks sales - last month sales)
row gives internal category and product
measure gives QTY and Value in selected currency