Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Pivot Formatting

72
Views
4
Comments
Prudence K
Prudence K Rank 5 - Community Champion
in Oracle Transactional Business Intelligence Forum

Content

Hi all - When I create a Pivot in Excel, it groups together rather than repeat each row.  This does not make it easy to filter the report after downloading.  Is there a way to repeat the rows for a summary?  I am taking a detail report (with 50+ columns) and pulling in only 5 of them for a summary report.

CustomerConnect.png

Tagged:

Comments

  • Dimple-Nagesh-Support-Oracle
    Dimple-Nagesh-Support-Oracle Rank 6 - Analytics & AI Lead

    Hi Prudence,

        Did you try normal Table instead of Pivot table, that doesn't group by default. Also you can see if you can repeat the columns, if they are supressed from cloumn properties to get the repeated values.

    Navigation  > Edit the report > Click on criteria Tab > Specific column > Column properties > Column Format.

     

  • Prudence K
    Prudence K Rank 5 - Community Champion

    Hi - when I pull a regular table in, it doesn't sum the salary together by the cost centers (like in my screenshot) unless I modify the code to do a GROUP BY.  

    Also, the options you provided me sound like a navigation for OTBI, but this report is in BIP.  Is this possible to do in BIP?

    I did a workaround of concatenating the fields together, but would like to not have to do that.

    Thank you!!

  • Robert Fighiroae-Oracle
    Robert Fighiroae-Oracle Rank 4 - Community Specialist

    Hi Prudence,

    Can you please provide some details about the setup of this BIP report? What template are you using? How did you design it etc.

    Best regards,

    Robert

  • Prudence K
    Prudence K Rank 5 - Community Champion

    Hi Robert - I didn't use a template, I just used the base report creation option that comes up when you are creating a new report.  So in the DM, I click Create Report and then on that first screen, I choose Use Report Editor because I prefer to design it myself.  When the report editor opens, I insert a Pivot Table and then pull over my pivot options.  I am thinking I need to use a different editor or update the DM somehow.  The DM is designed to pull over our employees' cost center information with their salary, incentive plans, etc.  So the detail works perfectly, now I just need a pivot summary by the costing information.