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 haven't signed up for your own EA3 instance, do so now at http://apexea.oracle.com.
...our journey continues
5 comments:
Hi Monty,
Yes, the APEX 5 enhancement on Interactive Reports are great, but I'm still not convinced end-users will embrace this as much as their beloved Excel or BI tool functionality.
If you really want to offer intuitive analyzing functionality in your APEX (4.2 or 5) application, you will need more advanced functionality. Have a look at this plug-in I developed: APEX SmartPivot.
(Sorry for this shameless plug ;-)
Cheers,
Christian
Tks, fellow!
Is it possible to make css change like row color based on certain conditions in pivot report?
Hi,
PIVOT in Apex provides MAX of three PIVOT Columns or ROW columns or FUNCTIONS. we can not add more.
I have a requirement to add more than 3 PIVOT Columns, ROW columns, and FUNCTIONS. Could you please let me know if you know any custom approach.
Thank You !!
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle APEX . Actually, I was looking for the same information on internet for
Oracle Apex Interview Questions and Answers and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
Post a Comment