This discussion is archived
2 Replies Latest reply: Sep 4, 2013 1:36 AM by BluShadow RSS

Using data as column names

Lucky7 Newbie
Currently Being Moderated

Hi Guys,

 

The data is like in the format below:

Item IDCOMMPLACRVESTB_ID
1Q4-2013Q4-20133
2Q4-2013Q4-20133
12Q3-2013Q3-2013Q4-20133

 

The requirement is to group the data by establishment id and the no of items commissioned, planned, revised and actual in a quarter.

 

The result set should be like:

 

ESTB_IDItem IDPL Q3-2013AC Q3-2013RV Q3-2013PL Q4-2013AC Q4-2013RV Q4-2013
31000101
32000101
312100010

 

What is the best way of achieving this result?

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points