This blog communicates with customers, partners, and the Dynamics community about the exciting developments related to CPM (Management Reporter, Forecaster and Enterprise Reporting) across all of the Microsoft Dynamics ERPs.
Monitoring your organization's performance when compared to a budget is a common business task. With Management Reporter, you can easily compare budget to actual balances, as well as view the supporting transactions. One feature that you may not be aware of, is that you can sort the report in order of variance dollars, variance percentage, or any other column on the report. Sorting by variance percentage makes it easy to spot what areas may require additional action.
Here is an actual vs budget report
Here is the same report, where the operating expenses have been sorted by variance percentage
And here is the Row Definition showing how this report was designed.
To define sorting:
1. Add the SORT Format code to the row definition above where you want the sort to begin (See row 2630 above)
2. In the Related Formulas/Rows/Units cell, type the range of row does to sort. For example, we used 2690:4430 in the example above
3:. In the Column Restriction cell, type the letter of the column from the column definition that should be the column that sorts. In the example above, the variance percentage column is E, so that was what was included
Management Reporter provides the following options for sorting:
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics