Hello. This spreadsheet was done by Steve Martin to create a waterfall chart by using fake dates and show missing values. In it he is still able to filter by "Order Date" and it doesn't change the waterfall. I've copied his process with my data set but when I try to filter on dates (each transaction has a date) it eliminates the waterfall.
How is he able to filter by dates? Spreadsheet attached.
Figured it out. It's by keeping null checked