I want to create a waterfall chart to show the liability movement from year to year. The dataset is on a sql server and it is a large one. It is hard to change the data structure. I have a simple example shown in the excel for the raw data and waterfall chart that I want. Can someone help to see how I could do this in Tableau?
I searched a bit and it seems if i change the total structure to have revenue, expenses, in one column and create a category field, then I can do a waterfall chart. But since the data structure is hard to change, is there a way to do it based on the current data structure?
I've had some success using a Custom SQL query in Tableau to re-structure SQL data...