Advanced Reports Background

<< Click to Display Table of Contents >>

Navigation:  Additional Salary Assessor Topics (Listed Alphabetically) >

Advanced Reports Background

The Advanced Reports tab allows the user to create large scale custom extracts of the Salary 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.  Salaries for various jobs reported by Years of Experience, Revenue/Assets and Levels 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 or Advanced Reports) 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. A maximum of 200 jobs is allowed.  The preview displays a limited number of jobs.  To view the full list, Export to Excel.

 

To Select Locations

1.Double-click on a row in the Areas table to select a location using the Select Area tool OR select a saved area list (saved in the Geographic List or Advanced Reports) displayed under the -- Select Saved Lists -- drop-down menu.  

2.The main Advanced Reports table will display a preview of all locations added to the Areas table. A maximum of 500 locations is allowed.  The preview displays a limited number of locations.  To view the full list, Export to Excel.

 

To Import a Job List

See Import Jobs

 

To Import an Area List

See Import Areas

 

To Select Compensation Type

See Compensation Type

 

To Select Pay Period

See Pay Period

 

To Customize Percentiles

See Customize Percentiles

 

To Customize Years of Experience

See Customize Years of Experience

 

To Customize Revenue or Assets

See Customize Revenue/Assets

 

To Customize Levels

See Customize Levels

 

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

See Salary Adjustments

 

To Export to Excel

See Export to Excel

 

To Print

See Printing