Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to transpose Rows to Column in OTBI Compensation Detail Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to transpose Rows to Column in OTBI Compensation Detail Report

Accepted answer
84
Views
14
Comments

Summary:

you can use a pivot table and have salary basis as column and value in the metric section, you should apply aggregation rule like min/max on the metric values.

I have create an OTBI Report for Compensation details where employee has multiple components like for example

32200061 ABC Basic - 49000

32200061 ABC DA - 12000

32200061 ABC HRA - 24000

32200061 ABC CLA - 1000

32200061 ABC TA - 300

32200061 ABC Petrol Reimbursement - 5000

Content (required): The user require that employee details should be visible in one single row instead of multiple rows.

Employee Code Employee Name Basic DA HRA CLA TA Petrol Reimbursement

32200061 ABC 49000 12000 24000 1000 300 5000

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!