Skip to Content
0
Former Member
Sep 04, 2013 at 10:31 PM

BEx report with CalMonth in column and qty in row for prior months

40 Views

Hello,

I have a requirement to create a BEx query where i need to achieve below results

Columns = Months, rows = Qty

Desired layout

(columns) July'13 Aug'13 Sep'13

(rows)

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.

Thanks,

MNK