Q? Developing plans frequently requires that corporate summaries are built from detailed input (bottom-up calculations) but that “What If”s are then applied to the summaries. How does your present system address this dual role?
The Pivot Table functionality allows both bottom-up and top-down changes to be applied to selections of data so that when totals are altered, underlying figures making up the total all change in proportion to reflect the change.
Benefit: Flexing plans becomes a simple and practical proposition with the benefit that many more scenarios can be tested in far less time.