New user here....
How can i pivot data in such a way that waterfall chart has 2019-2023 by account? Thanks!
My data (as an example) looks like this...
| Account | Description | Group | 2019 | 2020 | 2023 |
| 100000 | M&R | Production | 500 | 500 | 800 |
| 200000 | Salary | Operations | 1000 | 25 | 25 |
| 300000 | Burden | Sales | 200 | 300 | 400 |
| 400000 | Contractor | Unified | 100 | 100 | 100 |
| 500000 | Taxes | Territory | 200 | 200 | 200 |
| 600000 | Licensing | Etc. | 400 | 500 | 500 |
Would like to look like this
| Account | Description | Group | Value | Year |
| 100000 | M&R | Production | 500 | 2019 |
| 200000 | Salary | Operations | 1000 | 2019 |
| 300000 | Burden | Sales | 200 | 2019 |
| 400000 | Contractor | Unified | 100 | 2019 |
| 500000 | Taxes | Territory | 200 | 2019 |
| 600000 | Licensing | Etc. | 400 | 2019 |
| 100000 | M&R | Production | 500 | 2020 |
| 200000 | Salary | Operations | 1000 | 2020 |
| 300000 | Burden | Sales | 200 | 2020 |
| 400000 | Contractor | Unified | 100 | 2020 |
| 500000 | Taxes | Territory | 200 | 2020 |
| 600000 | Licensing | Etc. | 400 | 2020 |
| 100000 | M&R | Production | 800 | 2023 |
| 200000 | Salary | Operations | 25 | 2023 |
| 300000 | Burden | Sales | 400 | 2023 |
| 400000 | Contractor | Unified | 100 | 2023 |
| 500000 | Taxes | Territory | 200 | 2023 |
| 600000 | Licensing | Etc. | 500 | 2023 |
