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 |
