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
In the Search box, enter Analysis Column Templates, and then choose the related link.
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.
On the Home tab, in the Process group, choose Columns.
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. Choose the OK button to save your changed, or press the Esc key to close the windows.
 Tip |
|---|
For more information about how to work with fields and columns, see Work with Data. For more information about how to find specific pages, see Search. |