A waterfall chart helps you understand the cumulative effect of sequentially positive or negative values impacting a subtotal or total value. It's often used to visualize financial statements.
We will make use of the same Chapter 2 – Sales.qvf
application used in the Comparison recipe.
- In the application overview, click on the button in the top right-hand corner and click on the
Create new sheet
button. Name this sheetWaterfall
. - Once inside the newly created sheet, go to the
Charts
asset pane and double-click on theWaterfall chart
button . - In the properties pane to the right of your screen, click on
Measures
and clickAdd
. - Add the following line as the measure and label it
Total Commercial vehicle Sales
:
sum([Commercial vehicle sales])
- Add another line as the measure and label it
Total Non Commercial vehicle Sales
:
sum([Car sales])- sum([Commercial vehicle sales])
- Add another line as the measure and label it
Total...