display field across columns — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

display field across columns

Received Response
21
Views
1
Comments
deahayes
deahayes Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.