Automatic naming of the pie slice to 'Others' while using a 'Pie of a Pie' chart

[rohanmanx]

Hello,



I am creating a pie of pie chart on a pivot table. It auto names the slice it is supposed to aggregate together in the smaller pie as 'Others', I have been trying to name it to something that makes sense to the report readers here. Is there something that can be done in order for me to be able to name it differently.

[rohanmanx]

Hi,

Any help appreciated... is the query too convoluted? Can make it simpler if need be...

Thanks!