How to transpose Rows to Column in OTBI Compensation Detail Report

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):