Waterfall Chart Visual Questions

[Anonymous]

Hi,

I have this waterfall chart. I have two questions

1. Is there a way to trim the height of the total column to reflect the changes from previous month? So that users will be able to understand the trend from last month to current month? I want to trim the x-part here from the last place of the red bar (left of the blue bar). The blue bar should start on the vertical position based on the last place of the red bar. 

Something like this. I mean the blue bars' height are adjusted according to the bridges. 

2. Is there a way to drilll through the bridges between total columns (months)? By drill through means I can go to the raw data when I right click on the bridges. When I tested it, I can only drill through the blue bars. 

[TomasAndersson]

1.
Waterfall diagrams to that by default if the column put in "Breakdown" are parts of the total, see example: 

How is your data structured? It should work if it looks for example like below:

End of Month //or whatever date col	Category	Amount
2022-10-31	BFSI	$X
2022-10-31	Enterprise	$X

2. 
I would say normally the bars between the totals are a part of the raw data of the totals (depends on how your data is structured). If you want to a deepdive on certain categories, you could have a complementary visual and/or a drill-through page that allows the user to choose a category and see some more detailed data.