Forum Discussion
Solved
Waterfall Chart - Current vs. Prior
I want to build a waterfall chart that shows how / why cost increased over time from one month to the next. For now I'm looking at two periods: Last Month and This Month. What I'd like is this: ...
Okay, I figured it out. Solution below for posterity:
- Built measures for the delta between current and prior month
- Updated my "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta
- Added a total column which reprents the curent month
It looks like this:
Hi Bensiqc,
Can you share how you build the "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta?
I want to build similar waterfall chart but I do not know what measures to create in order to achieve this.
Thanks, Doris
Here's what I have.
My waterfall measure is written this way:
And I have a separate sheet where I add the index for those that looks like this:
| Measure | Index |
| CPP Prior Month | 1 |
| Net Freight Per Package Current vs Prior | 2 |
| Fuel Per Package Current Vs Prior | 3 |
| Accessorial Per Package Current Vs Prior | 4 |
| CPP Current Month | 5 |
Hopefully this helps.
Each of the measures referenced in the table (fuel per package current vs prior, etc.) were also created and added by me individually.