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.
Pivot Salary Data For Employee Population
Summary
Want to display salary data for employee population without summing the dataContent
Hi - I am trying to create a pivot table in OTBI that would show salary data and how many employees fall into that salary based on job title and department. However, when I am adding the salary field into the report, it is giving the grand total of the hourly wages for all employees that fall into that department and job title.
For example, I have 41 employees in a specific department that make 9 different distinct hourly wage amounts. However, instead of having 9 rows, I have one row that tells me the grand total of their hourly wages is 680.00
Tagged:
0