Categories
- All Categories
- 151 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
How to add column headers for pivoted fields in layout

Hello - I cannot find a solution to this yet I see many unanswered questions. I just need a firm 'no' if it's not possible. If it is, a brief explanation of how would be much appreciated.
When you add a pivot table to a layout in Oracle Business Intelligence Analytics - this is data model and report related, not analyses - column headers are not provided for the pivoted fields, that is the fields you select as rows. This seems like a major miss and would be unbelievable if it's not possible to add headers to those fields.
See screenshot below. The first three columns are my 'rows' for which I need headers (see my orange callouts with text).
I can tell you what doesn't work, adding the Text field value for Subtotal Row Label and Row Label Header.
Best Answer
-
Hi @Austin Rodola,
Welcome to the Oracle Analytics Community.
It seems it is not possible.
Please take a look into the following Oracle document where also the headers are not present for the screenshots used in the examples.
Additionally please find below the idea that has been raised for this feature. Feel free to vote and comment so that Oracle might introduce the feature in future release.
BI Publisher Pivot xpt layout only allows 5 row fields. Can this be increased ? — Oracle Analytics
Hope this help.
Thank you.
0
Answers
-
Thank you @Bhaskar Konar. I've added an up-vote to the linked idea you've provided. Hopefully they can get this rolled out soon.
1 -
Thank you very much @Austin Rodola!
0