Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
Select first 3 columns and click Unpivot other columns.
Gives you this:
Regards,
Tarun
Select first 3 columns and click Unpivot other columns.
Gives you this:
Regards,
Tarun
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |