Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Report Pivot View - Group Values in Row Together

rgiljohannFeb 7 2024

Hello, I have a pivot view in Interactive Report in APEX 23.2 I am trying to clean up to make it look a little nicer for end users. My data is by month, and those months are constantly changing, so I figured a pivot is the best way to show those months left to right in columns.

Is there anyway to make the rows look nicer if there is more than one column in the rows selection of the pivot? For example, in my example below, Medicare and Non-Medicare Episodic are both repeated 3 times.

Is there a way to make that show up as a block or heading, similar to the ‘Control Break' setting in the interactive report? If not, is there a way just to have the value show up once without being repeated? For example, it would just show Medicare in the first row, then have two blanks below it, and then show Non-Medicare Episodic in the 4th row, with two more blanks after. I think this might help a little bit at least.

Current Pivot:

This post has been answered by rgiljohann on Feb 8 2024
Jump to Answer
Comments
Post Details
Added on Feb 7 2024
4 comments
2,778 views