Hi All,
APEX 5.1 (but also checked on v20 on APEX.ORACLE.COM)
Is there an option to have more than 3 rows on the Interactive report pivot row column option.. It seems a real shame that such a great piece of functionality should be limited by the number of non pivot columns its allowed to display. ITs also nice that its dynamic. (i.e. you can filter the pivot columns easily to reduce your result set)..
The alternative is a manual pivot, which is far more clumsy, or concatenating columns, which is also messy.
I know there is a plugin out there, but it seems a bit overkill for my needs.
Rgds
Richard