The Customer Vs Product Sales Reports provide a matrix-based analytical view of customer-wise product sales within TUHUND. The report is designed to help organisations analyse which products are being purchased by specific customers across categories, brands and marketing zones.
Unlike contribution-based performance reports, this report presents customer-product relationships in a comparative matrix format where customers are displayed as rows and products are displayed as columns.
The report supports both quantity-based and amount-based analysis and enables users to monitor customer purchasing patterns across operational segments.
The report can be accessed through:
Sales → Reports → Customer Vs Product Sales Reports
The report may also be accessed through the Customer / Products utility option from related performance reports.
Purpose of the Report
The report is used to analyse customer-wise product purchases, compare product movement across customers and monitor sales distribution across categories, brands and marketing zones.
It also supports customer-level drilldown into detailed time-based product sales analysis.
The report is commonly used by sales teams, product managers, regional managers and management teams.
Report Interface
The report interface contains the following sections:
|
Section |
Description |
|
Entity Selection |
Filters report by organisation, company or branch |
|
Show Selector |
Filters report by business type |
|
Sort By Selector |
Defines report sorting |
|
Sort Order Selector |
Applies A–Z or Z–A sorting |
|
Category Selector |
Filters report by product category |
|
Brand Selector |
Filters report by brand |
|
Marketing Zone Selector |
Filters report by marketing zone |
|
Display Selector |
Switches between quantities and amounts |
|
Period Selector |
Defines reporting period |
|
Show Free Dates |
Enables custom date-range selection |
|
Report Matrix |
Displays customer-wise product sales data |
|
Export Button |
Exports report data |
|
Print Button |
Prints the report |
The ENTIRE ORGANIZATION selector functions similarly to other sales reports and allows users to generate reports for selected organisations, companies or branches based on access permissions.
Show Options
The Show selector controls which business segments are included within the report.
Available options include All, Products, Spares & Accessories and Virtual Products.
Virtual Products represent non-physical items such as licenses, subscriptions or other digitally delivered products.
Category, Brand and Marketing Zone Filtering
The report supports hierarchical category filtering through the All Categories selector, allowing users to analyse customer-product sales across parent categories, subcategories and nested category structures.
The All Brands selector allows users to filter the report for specific brands or all configured brands.
The All Marketing Zones selector allows users to filter data for selected operational or geographical marketing zones.
These filters enable highly targeted customer-product sales analysis across different business dimensions.
Sorting and Display Options
The Sort By selector controls report ordering and currently supports sorting by Company Name.
Users may additionally apply A–Z or Z–A sorting order.
The Display selector allows users to switch between:
-
Show Quantities
-
Show Amounts
This enables the report to function both as a quantity-based movement report and as a monetary sales analysis report.
Period Selection
The Period selector allows users to define the reporting period for analysis.
The report supports monthly, quarterly and yearly periods along with custom date-range selection through the Show Free Dates option.
Report Structure
The report is displayed as a customer-product comparison matrix.
Each row represents a customer, while each column represents a product or product grouping.
The matrix displays:
-
quantities,
-
or monetary amounts,
depending on the selected Display mode.
The Total row displays the aggregated total sales values or quantities for each product across all displayed customers.
This structure enables users to compare customer purchasing behaviour across multiple products simultaneously.
Drilldown Behaviour
The report supports customer-level drilldown functionality.
Customer names displayed within the matrix are clickable and open a detailed Time Chart report for the selected customer.
The Time Chart report displays time-based sales information for customer products across multiple months and reporting periods, allowing users to analyse purchasing behaviour over time.
Product identifiers displayed within the report are also clickable and support quick product ID copying functionality.
Export and Print Functionality
The Export button exports the currently displayed report matrix in Microsoft Excel (.xlsx) format.
The Print button generates a printable version of the report reflecting the current filters, reporting period and display configuration.
Data Representation
The report supports:
-
customer-wise product analysis,
-
quantity-based reporting,
-
amount-based reporting,
-
category-based filtering,
-
brand-wise analysis,
-
marketing zone filtering,
-
and customer-level drilldowns.
Displayed information varies depending on the selected filters, display mode and reporting period.
Where no data exists, the corresponding report cells may remain empty or display zero values.
Summary
The Customer Vs Product Sales Reports provide a detailed matrix-based analytical view of customer purchasing behaviour across products, brands and marketing zones within TUHUND.
By combining configurable filtering, comparative matrix analysis and customer-level drilldowns, the report enables organisations to analyse product movement, monitor customer purchasing trends and evaluate sales distribution across multiple operational dimensions.
