Forum Discussion

desertislesql's avatar
desertislesql
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago

Waterfall report starting value

I am looking for a waterfall report to look exactly like this Office 365 page. http://bit.ly/1MQVmJb  I want to have a starting value of budgeted value, chart the variances and end up with the actual...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
10 years ago

You can achieve it by data modelling (see this file).

Only thing I couldn't figure out is how to give the first column a different colour. Watch out for the sort-by-index column!

Dunners's avatar
Dunners
Icon for Advocate II rankAdvocate II
4 years ago

I like it in that you have created a work around. I don't like that MS still haven't made it easier all these years later, even though it's easy in Excel. Good work by you though 👍