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.
I added a bar chart of total sales. I just need the two steps in between to be those measures.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.