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

    Columns of Straight table



      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?