Open main menu

Other-Multi-Dimensional Analysis

Multi-Dimensional Analysis

This module allows user to flexibly define Multi-Dimensional Sales/Purchase/GL Analysis Report. Report layout can then be exported to Excel, PDF and Rich Text format.

Go to Tools > Program Control > Module Setting

Check the checkbox of Multi-Dimensional Analysis to enable it.


Multi-Dimensional Sales Analysis

Go to Sales > Multi-Dimensional Sales Analysis

Click on Inquiry.


 


Drag and drop Sales Agent field onto Row, and Month onto Column,

The analysis layout will look like this,

(remember that value displayed is Local Sub-Total)


 


Click on Set Sorting and Top Value Count,

Select field Sales Agent, sort on Sub-Total (means to sort Sales Agent based on total sales), and set Top Value Count to 3 (means to display only top 3 sales agents based on total sales).


 


Click on OK.


 

You may drag and drop more fields onto row/column for additional analysis,


For example, drag and drop Company Name field onto Row next to Sales Agent;

then drag and drop Item Type field onto Column next to Month, and drag and shift so that Item Type is placed before Month,


The layout will look like this:

 


By clicking on Export menu, you may send/export the layout to other format such as Excel, PDF, Rtf ...

 


By clicking on Layout menu, you may Save/Load the layout or Load the default layout:

 


Similar analysis is also available at:

Purchase > Multi-Dimensional Purchase Analysis and G/L > Multi-Dimensional Ledger Analysis.



Go to menu