Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
display field across columns
deahayes
Rank 4 - Community Specialist
Summary
display field across columns
Content
Hello all,
Im using BI Publisher EXCEL add on. I would like to display a field's values going across/horizontal instead of vertical. How can I do this in an Excel template?
Currently
204
205
206
Would like the following
204 205 206
0
Answers
-
I think you might be stuck pivoting the query first, then displaying the data. There is a pivot function in the RTF (Word) template, but I've not seen any Excel. The WYSIWYG template builder also has a Pivot object, then that report could be rendered in Excel as output.
0