I am working on creating a profit-loss chart, and I am wanting to create a waterfall chart that will show the following.
- 2 months ago, total revenue for overall company
-last month the total revenue for each department
- last month total revenue for company
I am wanting the waterfall to show how much of the total revenue is from each department. I have tried to use the bar offset, but the results are coming out wrong, I was using the previous months total revenue as a start point.
thanks for the help,
Mike