1 Reply Latest reply on Jul 11, 2017 8:53 AM by Alex Martino

    Month over month waterfall chart with formulas

    Alex Martino

      I can't find the answer to this anywhere and it seems so simple. I want to waterfall step two months total sales dollars by using volume and rate variances.

       

      Volume = (current month volume-prior month volume)*prior month average price

      Rate = (current month rate-prior month rate)*current month volume

       

      Spreadsheet attached.