Reviewing Sales Category Inquiry Column Information

You can compare sales statistics between months, quarters or years by selecting any of the following column views.

To view this month's sales and compare year to date sales for this and last year:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry screen.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Month/YTD/LYTD/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Month

Shows data according to the value you selected in the Sales Type field for the month you entered in the Date field.

YTD

Shows data according to the value you selected in the Sales Type field for the year up to the date you entered in the Date field.

Last YTD

Shows data according to the value you selected in the Sales Type field for the previous year up to the date you entered in the Date field.

% Chg

The percentage of increase or decrease in sales between the year you entered in the Date field and the previous year.

To compare year to date sales for this and last year:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select YTD/LYTD/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

YTD

Shows data according to the value you selected in the Sales Type field for the year up to the date you entered in the Date field.

Last YTD

Shows data according to the value you selected in the Sales Type field for the previous year up to the date you entered in the Date field.

% Chg

The percentage of increase or decrease in sales between the year you entered in the Date field and the previous year.

To compare sales for the last twelve months and the twelve months prior to that:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Last 12/Prior 12/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Last 12

Shows data according to the value you selected in the Sales Type field for the twelve months preceding the date you entered in the Date field.

Prior 12

Shows data according to the value you selected in the Sales Type field for the twelve months prior to the twelve months preceding the date you entered in the Date field.

% Chg

The percentage of increase or decrease in sales between the year you entered in the Date field and the previous year.

To compare sales for the current month and last month:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Month/Prior Mth/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Month

Shows data according to the value you selected in the Sales Type field for the month you entered in the Date field.

Prior Mth

Shows data according to the value you selected in the Sales Type field for the month before the date you entered in the Date field.

% Chg

The percentage of increase or decrease in sales between the month you entered in the Date field and the previous month.

To compare sales for the current month and same month last year:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Month/Month LY/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Month

Shows data according to the value you selected in the Sales Type field for the month you entered in the Date field.

Month LY

Shows data according to the value you selected in the Sales Type field for the same month you entered in the Date field, but for the previous year.

% Chg

The percentage of increase or decrease in sales between the month you entered in the Date field and the same month last year.

To compare sales for the current quarter and last quarter:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Quarter/Prior Qtr/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Quarter

Shows data according to the value you selected in the Sales Type field for the three months preceding the date you entered in the Date field.

Prior Qtr

Shows data according to the value you selected in the Sales Type field for the quarter before the three months preceding the date you entered in the Date field.

% Chg

The percentage of increase or decrease in sales between the quarter you entered in the Date field and the previous quarter.

To compare sales for the current quarter and same quarter last year:

  1. From the Reprts > Management Inquiries menu, select Sales Category Inquiry to display the Sales Category Inquiry window.

  2. Display sales information by sales category.

  3. Use the Columns hot key and select Quarter/Qtr LY/% Chg from the list.

If your selection in the Sort Column field no longer applies, the Sort Column selection list displays. Select a new value and press Enter to update the screen.

  1. For your selected sales category, review the following information in each column, as needed:

Column

Description

<Sales Category>

The values for the category you selected in the Category field. For example, if you selected Product Budget Group, all of your sales budget group IDs display.

Quarter

Shows data according to the value you selected in the Sales Type field for the three months preceding the date you entered in the Date field.

Qtr LY

Shows data according to the value you selected in the Sales Type field for the same three months preceding the date you entered in the Date field, but for the previous year.

% Chg

The percentage of increase or decrease in sales between the quarter you entered in the Date field and the same quarter last year.