Working the grid
The grid is the main information source for Salesmatrix.
It provides a dynamic environment where sales performance results can be compared and analysed.
Toolbar
Actions:
Clicking each button has a particular task or function. See
Toolbar.
Can also be hidden via menu item "Hide Toolbar"
Sidebar
Controls Four tabs, 'Categories' and the three key
aspects of the Salesmatrix equation ie 'SalesPersons'/'Customers'/'Products'
Actions:
In Customer
by Product, and Product or Customer by Period views, choosing one
SalesPerson will show only the Customers and Products sold by
that Salesperson.
Dimension Filters
Opens up tabs to allow the choice of one item to filter by.
For example all Products purchased by one customer, or one
salespersons customers or one products customers can all be
viewed.
Column Tabs and Row Tabs
"Category" mode
Contains the list of independent categories and subsequent
breakdowns for the vertical axis.
Actions:
Clicking
one of the folders displays the individual terms in that category.
You can click on any category or item
under a category to narrow your data set. In the
default settings "Detailed" rows appear as cream, while "Total" (summarised)
rows appear grey with total in the title.
"SalesPersons/Customer/Product" mode
Contains a list of each of the members of the respective
aspect.
Actions:
Clicking on a SalesPerson from the nodes on the sidebar tree filters the
grid, reveals details only pertaining to
the selected SalesPerson. The same goes for each of the other
two aspects.
This is especially powerful for viewing what Products each
customer has purchased, or which Customers have purchased a
particular product.
Grid Title
Gives a full description of the data displayed in
the grid.
Column Titles
Actions:
Clicking a column header will sort the
column from lowest to highest. A subsequent click will reverse the sort
order
Row Totals
Actions:
Double-Clicking the description area will sort the row from the lowest column to highest column. This also works for Total columns. A small information dialogue may appear while the sorting is completed.
Data Cells
Actions:
Double clicking a data cell will "drill-down" into the details behind the cell and open the Matrix Details window
Depending on the grid that is drilled -down into, this screen may show a number of tabs displaying information about the cell.
The first tab displays a summary of the key details of the transactions. The remaining tabs display the other aspects of the cell. For example if the display is Salesperson by Period, the Matrix Details are will display the Products sold and Customers sold to for that cell. Similarly if the display is Products by Customers, the matrix details will show the periods the transactions fell into, and the Salespersons responsible for the sale.
The quadrants view drill-down will display all four aspects of the data displayed including the clients that fall within that quadrant cell.
The Revenue, Margin and Units display can be sorted in ascending or descending order by clicking on the titles of these columns.
Right clicking
on a cell will display a menu enabling access to the key functionality of Salesmatrix
The Copy button 
in the bottom left allows the contents of the grid to be transferred to
other software packages (eg MS Excel/Word etc)
Copyright
|
