5 Replies Latest reply: Mar 4, 2011 5:04 PM by Gabriela Morales RSS

    Columns of Straight table

    HeyZeusChris

      Hi,

      I am a loading a table from sql. The query is like this:

      Select Year, Product, Bookings from BookingTable

       

      There are 5 distinct products:

      ProductA ProductB, etc.

       

      From this table I want to make a table that has Year, and the distinct Product Names as the columns.

       

      So it would look like:

      Year, ProductA, ProductB, ProductC...

      2011 $1 $2 $3

       

      Anyone know if this is possible?

       

      Thanks!