1 Reply Latest reply on Jul 9, 2018 10:07 PM by Alex Martino

    Using "Missing Values" for a waterfall but still filtering by dates

    Alex Martino

      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.