Comment on page
Waterfall Schemes
Innofalls offers various ways to create a waterfall chart. Which scheme you choose depends on what you want to compare.
If you want values to be summed up to a grand total (like in a profit and loss statement), you would create a Running Totals Waterfall Chart.
If you want to compare two or more members, you need a Delta Waterfall Chart.
To compare two or more measures you have to create a Measure Delta Waterfall Chart.
By default the waterfall scheme is set to Auto:
If Auto is selected, the waterfall will be shown as a running totals waterfall, unless two or more elements in the drill down history are selected. Then a delta waterfall is built. With one exception: If the selected elements don't have children in common (like Quarters, which have different months as children), a running totals waterfall will be built.
The running totals display breaks down a final sum into consisting contributions. It is often used for income statements and alike.
A simple running totals waterfall chart
Unless you made a drill down and selected only one element, this always displays the waterfall as a delta waterfall chart. Even when the case above occurs that the elements do not share children.
A delta waterfall chart
The measure delta waterfall can not be selected from the menu. Instead, you have to add at least one measure into the Values From field.
You can add more than one measure into Values and / or Values From. The measures are added up respectively and the delta is calculated between the sum of them.
A measure comparison waterfall chart from PP to AC
Last modified 6mo ago