Pivot Formatting

Prudence K

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.

Dimple-Nagesh-Support-Oracle

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

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

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

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.