Forum Discussion
vickychill
3 years agoFrequent Visitor
Creating Stacked column chart with more than one X-axis
Hello community,
I have a table something like below and want to show the data as below for each year in one column chart. I read people suggesting to unpivot the table but the table is huge (with more than 10K rows) and will make this complex. Is there an easier way to do this?
| Product ID | Sales 2021 | Sales 2022 | Sales 2023 |
| 1 | 100 | 102 | 104 |
| 2 | 200 | 200 | 210 |
| 3 | 300 | 350 | 360 |
| 4 | 400 | 401 | 420 |
Thank you in advance.
1 Reply
- Ashish_MathurSuper User
Hi,
Unpivoting is the only and therefore the best way.