I need a multi-level nested pie chart in google sheets. To show number sums in categories and sub-categories. Can use code or just formulas.

Or if a system similar to google sheets already has a easy configurable nested pie-chart I can consider using it.

Here is a sample sheet with 2 charts I want to combine:

It can be similar to the one here, but with sums instead of counts:

• next, for each colored column we create a separate pie chart that we overlay on top of the base pie chart. note that colors and sub-colors needs to be selected manually for each slice by double-clicking a given slice and selecting either color or none in the case of ♀♂ slices

and repeat for the next column...

demo spreadsheet