From time to time we need to pivot data for presentation purposes. It’s not something I do everyday, so the syntax is usually something I have to pull from the old toolbox as needed. With Oracle APEX 5.0, you can now pivot data within an interactive report and it’s quite easy.
Let’s say we’ve got a table of Super Bowl quarterbacks and their pass attempts per quarter.
…but we really would like the data displayed where we can compare the quarterbacks side by side…a textbook pivot. To accomplish this, go to Actions / Format / Pivot. There you see a dialog box that requests the pivot column, the row columns and the data to be included in the grid. The “Sum” checkbox does exactly that…totals the columns.
…resulting in the following output.
Obviously you should season to taste, but there you have it! Your data instantly pivoted courtesy of APEX 5.0
If you have data presentation requirements you just can’t crack, please contact me for a free consultation. Making the call could be, well…PIVOTAL.