The Advanced Reports tab allows the user to create large scale custom extracts of the Executive Compensation Assessor database. This feature enables the display of compensation for multiple user-selected job titles in various geographic locations in one table. The user can customize the Compensation Type, Pay Period, and Percentiles displayed in the table. Compensation for various jobs reported by Revenue/Assets can be analyzed at once in a single table.
Please note: The Advanced Reports table displays only a preview of the entire table with a limited number of records. Export to Excel to see all results.
To Select Job Titles
1.Double-click on a row in the Jobs table to select a job title using the Search Jobs tool OR select a saved job list (saved in the Benchmark List) displayed under the -- Select Saved Lists -- drop-down menu.
2.The main Advanced Reports table will display a preview of all job titles added to the Jobs table.
To Select Locations
1.Double-click on a row in the Areas table to select a location using the Select Area tool.
2.The main Advanced Reports table will display a preview of all locations added to the Areas table.
To Display Base Salary, Total Cash, or Incentive
To Select Pay Period
See Pay Period
To Customize Percentiles
To Customize Revenue or Assets
To Save a Job List or Area List
See Save Table
To Sort a Table
See Sort Table
To Delete a Row in the Job List or Area List
Click the delete row button (
) on the right side of the row you want to remove.
To Delete All Rows in the Job List or Area List
Click the delete all rows button (
) found in the top right corner of the table.
To Edit Organization Data
To Export to Excel
See Export to Excel