How do I subdivide a pie chart in quicksight?

I have a pie chart showing

Option A: 10%
Option B: 50%
Option C: 30%
Other: 10%

I want to subdivide ‘Other’ into other categories and show the percentage of each sub-category over the whole.

Hey @Drish ,

you would need to create a calculated field for your use case.

ifelse(Main = 'Other',sub-category,Main)

That should work.

BR
Robert

1 Like