To make Drill Down Waterfall PRO calculate all subtotals, there are two things that you need to do:

1. Provide a sequence field. This will make it so that categories without values need to be displayed in the visual.

2. Go to Formatting options > Column Settings > Sub Total Mode – set this to All. You can read more about other modes here - https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/documentation/drill-down-waterfall-visual/formatting-options/column-settings/sub-total-mode/

By default, Drill Down Waterfall PRO will sort the data in descending order. This means that it will go from the highest increase to the lowest decrease. You can also turn this around with the ascending order. If you want to control exactly where the category is placed, use the sequence field and provide an index column for the sorting order.

To find out more about Drill Down Waterfall PRO, you can visit these two resources:

1. ZoomCharts Academy - https://academy.zoomcharts.com/courses/visualize-data-with-drill-down-visuals-advanced/drill-down-waterfall-pro-visual/intro

2. Documentation section - https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/documentation/drill-down-waterfall-visual/

To see all supported interactions, watch this demo - https://academy.zoomcharts.com/courses/visualize-data-with-drill-down-visuals-advanced/drill-down-waterfall-pro-visual/interactions