Tabulations

Most analysis tasks can be solved by using tabulations. The data previously retrieved in spreadsheets for final refinements in relation to your presentation requests, can easily be modified in InfoSuite. In this way you can avoid a lot of extra work. Once the tabulation is saved, it can be used over and over again.
Tabulations give you the following grouping optios:

• Add list of values. You create the groups needed and the relevant values are placed manually in the group where they belong. Could be attachment of customers to customer groups or districts
• Range. This is a from-to function. It is used for example by creation of profit and loss accounts, where the different groups of the profit and loss accounts are created. Could be the turnover, which is identified by the range from generic account 11.000 to generic account 11.999. After that, cost of sales is created etc.
• Calculation. This function is used for making calculations based on the other groups added to the tabulation. You could for example create the group Contribution margin and then be calculated as Turnover - Cost of sales.
• Selection. Using a selection gives you more opportunities such as Including, Inside range, Outside range, >, <, = etc. It can be used on ID, description as well as the analysis fields. It can for example be used if you wish to find all customers with a turnover above 500.000,-. Or if you in the description of your products need all that include the text Jeans...
• Top/bottom. It is possible to select the 10 largest customers (top 10) or the customers making up for 80% of the turnover. It can be used for creating an ABC analysis. For example calculation, selection, range top/bottom (top 10), addition of values. You can process your data in InfoSuite (in stead of speadsheet), save it and work with it over and over again. Examples: Profit and loss accounts, focus products across item groups, salesman districts across ERP division etc.

Return