Print control for conditonal columns example in Management Reporter

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:

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

  2. For the actual column, in the Print Control row, enter the conditional operator P<=B.

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

  4. Click OK.

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.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!