The steps below will walk you through creating a ranking report on the Reports tab and allow you to rank by your choice of multiple items.
Step 1: Navigate to the Reports page and click on the “Create New Report” button.
Step 2 - Select the Type of Report: The option for the report we are creating here is Matrix Report - Ranking. Select the option from the dropdown and click Next.
Step 3 - Name: Type a name for your report. You have the option of entering a description as well. You will see the option to “Ask each time this report is run” on each step of this process. Only select this box if you want to be asked for the information on the page each time the report is run. You also have the option on this page for Report Availability. This setting allows you to make the report visible to only the person creating the report or everyone that has access to this Dealership or Group reports. When you are ready to move forward, click the “Next” button.
Step 4 - Date: Choose the date parameters for your report. You can choose current month, a specific date range, or advanced options.
Current Month: the report will include deals that have the month of sale corresponding to the month listed at the top left of your Reporting application.
Select Date Range: the report will include deals based on the delivery date of the sale
Advanced Options: lets you choose options such as individual months, previous month, or even year to date.
This step is a good step to utilize the “Ask each time this report is run” option since reports usually depend on a specific date range. When you are ready to move forward, click the “Next” button.
Step 5 - Grouping / Order By: The Page category will determine the display for each page of the report. For example, to see the data for each finance manager on separate pages, choose Finance Manager from the drop down. Note: Self refers to the dealership or group as a whole, so one page.
The Row category will determine what type of data will be displayed in each Row. For example, to sort the data in each Row by Finance Manager, choose Finance Manager from the drop down.
The Order by section allows you to select what you are ranking by. You are able to select to rank by any item in the dropdown. Once you have selected the item then select what data from that item you would like to rank under Data Type. The Direction allows you to choose if you want the number to Ascend or Descend from the top of the report. When you are ready, click the “Next” button.
Step 6 - Filters: Filters on a report allow you to choose what to show or hide on a report as it relates to Transaction Type, Deal Type, Lenders, and Personnel (Finance Manager, Sales Manager, Sales Person, etc.). All of the filter options are selected by default. Selected items are included in the report. You should unselect the box next to the data, if any, that you want excluded from the report. When you are ready to move forward, click the “Next” button.
NOTE: If you do not see your personnel listed as a filter, this means that you have excluded them from being included in reports. To see how change this, reference the "Add / Edit Drop Down Options in Reporting" article by clicking HERE.
Step 7 - Profit Center Grouping: The Reporting system has the ability to group all the products in a profit center category together for reporting purposes. If you want the products displayed individually on the report, then leave the Grouped box unchecked. Check the box if you want them to be displayed as one figure. When you are ready to move forward, click the “Next” button.
Step 8 - Click-Thru Format: Your finished report will have click-thru links that can be clicked to see the details of the data.
In order to choose which columns of data to include in the click-thru, highlight an available column and click on the right facing arrow. Your selection will move to the Selected Columns field.
To reorder the columns, click on the selected column you want to move and click the up or down arrows to move it.
To remove a column from the click-thru report, click on the selected column you want to remove and click on the left facing arrow.
There are additional options below the Selected Fields Column. For the "Use Dropdown Abbreviations in Report" option: uncheck the box if you want to see the full name data of the selected columns in the report; check the box if you want to see only the abbreviation of the data in the report. If you do not want the ability to review or edit the items in the click-thru report, click the "Hide the 'Review' and 'Edit' Columns" box. NOTE: If numbers are listed in your reports instead of names, it is likely because the "Use Dropdown Abbreviations in Report" is checked. Uncheck the box to see names instead of numbers.
When you are ready to move forward, click the “Next” button.
Step 9 - Click-Thru Settings: This section allows you to change the width of the columns on the click-thru report.
Click on the pencil icon next to the column name. The line will highlight and populate up top.
Then change the width. There is a option for Custom that allows you insert a value under inches.
Click the Save to save the changes.
When you are ready to move forward, click the “Next” button.
Step 10 - Show/Hide Data: This section allows you to hide unit count, penetrations, income and averages for products (profit centers). This feature also allows you to hide a product completely. For example, you could choose to show GAP as a unit count and hide the penetration, or hide GAP all together. NOTE: The first section is scrollable. If you do not see an option you want to exclude, hover your mouse over the section and scroll up or down.
All of the data options are selected by default. You should unselect the box next to the data, if any, that you want excluded from the report. The data for the excluded fields will still be included in your totals but will not show on the report. When you are ready to move forward, click the “Next” button.
Step 11 - Finish: If you don’t want for anyone to be able to edit or delete the report, check the Lock Report box. You can also decide what orientation and paper size to use when you print the report. When you are finished, click the “Save” button.