Sales Summary By Filter

The Sales Summary By Filter Table allows you to drill down into your sales for the past month, offering monthly and yearly comparisons across your sales.

 

Columns

The following columns are present in every table under this panel:

MTD Sales

The total value of all sales for this row so far this month.

MTD $ Difference ($ Diff.)

he difference in sales so far this month compared to last month.

MTD % Difference (% Diff.)

The difference in sales so far this month compared to last month, as a percent value.

MTD GP%

The gross profit so far this month, as a percent value

MTD GP% Difference (Diff.)

The difference in gross profit so far this month compared to last month, as a percent value.

MTD% Returns ($ Ret.)

The number of items that have been returned this month compared to the number of items that have been bought this month, as a percent value

YTD Sales

The total value of all sales for this row so far this year.

YTD $ Difference ($ Diff.)

The difference in sales so far this year compared to last year.

YTD % Difference (% Diff.)

The difference in sales so far this year compared to last year, as a percent value.

YTD GP%

The gross profit so far this year, as a percent value

YTD GP% Difference (Diff.)

The difference in gross profit so far this year compared to last year, as a percent value.

YTD% Returns (% Ret.)

The number of items that have been returned this year compared to the number of items that have been bought this year, as a percent value

 

Tables

The following tables are available within this Sales Summary By Filter panel

Customer

A listing of each customer you have sold a product to in the current time frames, with their account number and name available. Drills down on the "Account" column.

Customer > Category

A listing of each category that has been sold to the parent customer with the category and description available. Drills down on the "Category" column.

Customer > Category > Part

A listing of each part that belongs to the parent category, that has been sold to the parent customer with the item code and description available.

Item Category

A listing of all the item categories you have sold within the current time frames, with their category and description available. Drills down on the "Category" column.

Customer Territory

A listing of all the territory values for which you've sold to a related customer within the current time frames, with the territory value available. Drills down on the "Territory" column.

Territory > Customer

A listing of all the customers for which you've sold a product in the current time frame belonging to the parent territory value, with the account number and name available.

Industry Code

A listing of all the industry code values for which you've sold to a related customer within the current time frames, with the industry code available. Drills down on the "Industry Code" column.

Discount Group

A listing of all the discount group values for which you've sold to a related customer within the current time frames, with the discount group value available. Drills down on the "Discount Code" column.

Discount Group > Customer

A listing of all the customers for which you've sold a product in the current time frame belonging to the parent discount group value, with the account number and name available. 

ACA Category

A listing of all the available ACA categories for which you've sold a product within the current time frames, with the category and description being available. Drills down on the "Category" column.

ACA Category > ACA Subcategory

A listing of all the available ACA subcategories related to the parent ACA category for which you've sold a product to a customer within the current time frames, with the SubCategoryID and SubCategory Name available. Drills down on the "SubCategoryID" column.

ACA Category > Category

A listing of all your product categories for which you have a sold aproduct that matches the parent ACA Category within the current time frame.

ACA Category > ACA Subcategory > Products

A listing of all the products associated with the parent ACA subcategory for which you've sold to a customer within the current time frames, with the item code and description available.

Class

A listing of all the classes for which you've sold a product to a customer within the current time frames, with the class ID and class name available.

Class > Subclass

A listing of all the subclasses related to the parent class for which you've sold a product to a customer within the current time frames, with the subclass name available.