How to: Set Up Analysis Column Templates

In an analysis report your analysis parameters are shown as columns. You can define the columns that you want to include in your analysis report by setting up analysis column templates.

A template contains a set of lines each representing the analysis columns that you see in the analysis report. To define a column you must assign an analysis type code to a line. This analysis type code determines the type of source data in the item ledger entries that the analysis will be based on. Source data includes cost, sales amount, or quantity, and their associated value entries. You can set up as many column templates as you like, and then use them to create new analysis reports.

To set up analysis column templates

  1. In the Search box, enter Analysis Column Templates, and then choose the related link.

  2. Select the first empty line, and in the Name field, enter the name you want to give your new analysis column template. In the Description field, enter a description.

  3. On the Home tab, in the Process group, choose Columns.

  4. In the Analysis Columns window, fill in the fields to specify the columns that you want to include in your analysis report.

    Note

    To define a column, you must fill in the Analysis Type Codes field for all column types except Formula. Set up the analysis type codes in the Analysis Types window.

    Note

    In the Ledger Entry Type field, if you select Item Entries, the actual figures from the item ledger entry are copied. If you select Item Budget Entries, the budgeted figures from the budget are copied.

  5. Choose the OK button to save your changed, or press the Esc key to close the windows.

See Also

Tasks

How to: Set Up Analysis Line Templates
How to: Create New Inventory Analysis Reports
How to: Set Up Analysis Types

Other Resources

Filling in the Column Type field