You can use conditional column options to conditionally display or omit any column depending on the relationship between the column's fiscal period and the base period for the report.
For example, you can create a report that displays 12 different periods in which actual amounts print for the base period and for all prior periods. Also in this report, the forecast amounts from an external spreadsheet print for all future periods. This report dynamically derives the correct data for the actual amount, budget amount, or forecast amount, based on the base period for which the report is run.
To set up the example conditional report, do the following:
Create a column definition with two columns for each period.
The first column for a period contains actual amounts, and the second column for that period contains budget amounts.
For the actual column, in the Print Control row, enter the conditional operator P<=B.
For the budget column, in the Print Control row, enter the conditional operator P>B.
Note: When a column is suppressed by a conditional option, it is not included in any calculations.
You can also add a Total column that totals all of the periods in the year. However, if you specify a range of columns in the total, Microsoft Office PerformancePoint 2007 Management Reporter includes only columns that actually appear in the report.