I have a SQL query that outputs data in a normalised style...
Column1 = Row Heading
Column2 = Column Heading
Column3 = Cell Value
Is there a straight forward way to output data in this format? Once output as a grid, I also would like to chart the values, with each Column Heading representing a Data Series in the chart.
And on a side note, does anyone have any links to a decent APEX 2.x tutorial? I've found a couple of poor / short ones, but not a good one...