Hi, I am looking to build a profit bridge between two different time periods. I would like to plot base period margin, $'s from price, $'s from cost, $'s from volume, and the current period margin. I believe this should be approached like a waterfall, but when I bring in the time component in the column shelf, things start looking odd. Does anyone have experience with successfully doing this?
Would you be able to post a sample workbook (twbx file)?