I am looking to build a nested pie chart using a donut chart and am unable to figure out how to do this with a pivot table. I'm hoping to use the same data source as the rest of the charts and not wanting to create a new table just for this nested view, but understand that may not be possible. Below is an example of the data I would be using, but it would be in a Pivot table as it is not originally given to me this way. I'd like the inner table to show the year and the outer table to show the quarters for each year.
The goal would be to make something that looks like this, but from the pivot table at the bottom of this question.
The goal would be to make something that looks like this, but from the pivot table at the bottom of this question.
Year | Quarter | Sales |
2021 | 4 | $500 |
2022 | 1 | $600 |
2 | $700 | |
3 | $800 | |
2023 | 1 | $900 |
2 | $1,000 | |
3 | $1,100 | |
4 | $1,200 | |
2024 | 1 | $1,300 |
2 | $1,400 |
