Multi-Dimensional Analysis

From AutoCount Resource Center

Other-Multi-Dimensional Sales 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.

Go to Sales > Multi-Dimensional Sales Analysis

Click on Inquiry.


MDS1.png


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)


MDS2.png


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).


MDS3.png


Click on OK.


MDS4.png

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:


MDS5.png


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


MDS6.png


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


MDS7.png


Similar analysis is also available at:

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



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations