Vertical Pivot
Ravi.KMay 31 2011 — edited May 31 2011Hi,
I have data as follows.
BUSINESS DATE BUSINESSTYPE Amount FLAG
2011-02-05 AB 100 B-Amount
2011-02-05 AB 200 P-Amount
2011-03-20 XY 500 B-Amount
2011-03-20 XY 400 P-Amount
2011-03-25 CD 700 B-Amount
2011-03-11 DC 900 P-Amount
I want data should be as follows group on business date and Business Type.
BUSINESS DATE BUSINESSTYPE B-Amount P-Amount
2011-02-05 AB 100 200
2011-03-20 XY 500 400
2011-03-25 CD 700 0
2011-03-11 DC 0 900
Thanks...