How To: Defining New Columns (05-41-01)

Overview

By default, the Sales by Store report includes columns for the following:

  • Store Name
  • Sales Dollars
  • Number of Tickets
  • Gross Margin Percentage
  • Return Percentage
  • Average Number of Units*
  • Average Unity Price*

To add columns that report on a specific product type or department, complete the steps in this tutorial.

NOTE: This feature is only available on Non-POS terminals.

* Based on Preferences (05-90-03-01)

Step-by-Step

Click image to enlarge.

1. Click the ‘Define Columns’ button at the bottom of the Sales by Store screen. The ‘Definable Columns Setup’ window appears.

Click image to enlarge.

2. In the ‘Title’ field, type the name of the new column.

3. In the ‘Prod/Dept’ column, specify whether you want the new column to report on a specific product type or a specific department.

4. Depending on your choice in Step 3, select a product type or department from the ‘Product Types to Select’ or ‘Departments to Select’ drop-down menus, respectively.

5. Click the arrow button to add the selected product type/department to the ‘Value’ column.

6. Repeat steps 2-5 until all columns are set up.

7. To delete a column, clear the ‘Title’ field and press Tab.

8. Click ‘OK’ and the window closes.

Click image to enlarge.

9. Click ‘Refresh’ on the main screen to update the report information. The column(s) you just created now display.

Tags: