Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
For example I have a view FAC_TIMESHEET_VIEW and data like table below
After that, I create a function to pivot data by USERNAME
How can I create an iteractive report to show above data (dynamic column horizontal)
Your question isn't completely clear to me, but you may wish to read
or play with APEX 5 pivot
Monty Latiolais: Pivots Made Easy with APEX 5.0