Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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):
Tagged:
0