Custom column to show salaries & compensations

Question

Hi experts, I'm trying to get an analysis to show the salaries and compensations of employees from SA "Payroll - Element Entries Real Time".

My question is how can I show the salaries/compensations of each employee in 1 row with different columns instead of having repeated rows for each employee like in the picture below:

Creating custom columns using formulas may help but I have no idea how to write it. Can anyone help? Thanks.

Bhaskar Konar · Answer

Hi @Steph Yeung,

You can achieve it using Pivot Table.

Place your 'Element Name' in the Column Section and 'Displayed Input Value' in Measure Section. Select some 'Aggregation Rule' for 'Displayed Input Value'.

Please find below the screenshots.

Pivot View Settings:

Aggregation Rule:

Table vs Pivot:

Hope this help.

Cheers,

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/23900/custom-column-to-show-salaries-compensations

Can you please try the solution mentioned in below MOS?

Oracle Fusion Recruiting Cloud: OTBI: How to Transpose Values from Rows to Columns in a Report (Doc ID 2878783.1)

Thanks.