Configuration Screen

Choose the dimensions and measure you wish to be displayed in your Waterfall Chart. Be sure to add any missing dimension or measure to your data worksheet and reload the extension.

Waterfall Chart configuration panel -> Configuration

Category

The category will be the starting and ending point of the series. In our example this will show us which category produced the biggest sales in each particular year. Other categories could be revenue to net income , the waterfall chart will portray how your initial value is affected by a series of intermediate positive or negative values.

X Axis

The X Axis should be the series of dimensions that are being measured by your chosen measure. For example the profit and loss per department of your organisation, over a year. The series will show all departments and the effect they have on your companies revenue.

Measure

Use the Waterfall Chart to show the total sales through the year or just the profit to see which department or item is bringing in the best value. Add your measure here.