Comparison Pivot

The Comparison Pivot report allows users to view results from multiple scenarios in a single pivot report. Comparison Pivots behave and function the same as regular Pivot Reports, with two main differences:

  1. Default Scenario field must be present in the Row or Column Areas.

  2. Chart types have been reduced to those suitable for comparison purposes.

For full instructions on how to create and use Pivot Reports, see: Pivot Report

Comparing Multiple Scenarios

Controlling what scenarios to compare is handled via the Scenarios Panel.

The selected scenario is considered the root scenario. Other scenarios with a tick in the compare column will be compared against in the calendar.


Comparison Pivot: Multiple scenarios