Advanced Reports Background

<< Click to Display Table of Contents >>

Navigation:  Additional Executive Compensation Assessor Topics (Listed Alphabetically) >

Advanced Reports Background

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 areas in one table.  The user can customize the Compensation Type, Pay Period, Percentiles, and Organization Size displayed in the 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.To select a job title, double-click on a row in the Jobs table OR click the button to open the Browse Jobs dialog.

2.To select a saved job list (a benchmark list saved in the Benchmark List or Advanced Reports), highlight a list displayed in the saved list menu.  

3.To upload a list of job titles, see Import Jobs.

4.The main Advanced Reports table will display a preview of the job titles added to the Jobs table. To view the full job list, Export to Excel.  

 

To Select Areas

1.To select an area, double-click on a row in the Areas table OR click the button to open the Browse Areas dialog

2.The main Advanced Reports table will display a preview of the areas added to the Areas table. To view the full area list, Export to Excel.

 

Note: When the performs a Search by ZIP Code and selects a area listed, then the Advanced Reports table will display a Postal Code column (in enhanced editions only).

 

To Import a Job List

See Import Jobs

 

To Create an Organization Profile

See My Organizations

 

To Display Base Salaries, Total Cash, or Incentive

See Compensation Type

 

To Select Pay Period

See Pay Period

 

To Customize Percentiles

See Modify Percentiles

 

To Customize Organization Size

See Change Organization Size

 

To View a List of All ERI Areas or Jobs  

See Data Availability

 

To Save

See Save List

 

To Sort a Table

See Sort Table

 

To Delete a Row

See Delete Table Rows

 

To Edit Organization Data

See Organization Data

 

To Export to Excel

See Export to Excel

 

To Export Large Reports

See Download Center