Showing intermediate total bars

In a waterfall chart, a total bar showing the resulting value for the entire waterfall chart is shown by default. You can also show intermediate running totals.

About this task

The intermediate totals can be shown in waterfall charts where a categorical coloring is applied, and in waterfall charts with a hierarchy on the category axis.

Before you begin

A hierarchy must be specified on the category axis, or a categorical coloring must be applied on the color axis.

Procedure

In the visualization properties, locate the Total bars section.

Note: In the visualization properties panel, the total bars are shown in the visualization when the Total bars card is added to the panel. In the visualization properties dialog or popover, you must select the Show total bars check box.
To remove the total bars, remove the card from the panel or unselect the check box.
If you want, you can use the color palette to specify the color of the total bars.
Select the One total bar after each value in radio button.
(In the visualization properties popover, this option is called One total bar per value in.)
In the drop-down menu, select the column containing the values after which you want to display totals.

Results

The intermediate total bars are shown.

Note: Adding intermediate total bars to a hierarchically structured waterfall chart displays the category axis scale labels in a flat structure as shown in the waterfall charts above.