I have a requirement to create a BEx query where i need to achieve below results
Columns = Months, rows = Qty
(columns) July'13 Aug'13 Sep'13
Qty(on 1st business day of month) July'13 data Aug'13 data Sep'13 data
Qty(on 1st business day of month for 3 mnths prior) May'13 data Jun'13 data Jul'13 data
Any suggestions would be highly appreciated.