How to transpose Rows to Column in OTBI Compensation Detail Report
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):