Hello,
Anyone had ever created waterfall chart with Totals on either side and variance as waterfall.
Below is the table with dimension values and measure. attached layout i'm trying to achieve.
Region(Dim) | Sales | Traget sales | Variance[C-B] |
line 1 | 14 | 10 | 4 |
line 2 | 11 | 12 | -1 |
line 3 | 21 | 23 | -2 |
line 4 | 26 | 23 | 3 |
line 5 | 20 | 23 | -3 |
line 6 | 23 | 20 | 3 |