Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |