"Others" Dimension in Pie chart

[#1]

Hello All,

I have a requirements that the top 10 dimensions (sorted by sales) in a pie chart show with different colors. Remaining other dimensions (NON TOP 10) should show in one pie slice using single color.

I can color different pie slices from the back groud expression, but I need a dynamic solution. Also the top 10 dimensions of today, may not be top 10 for tomorrow.

Any thoughts?

Or will I have to go the calculated Dimensions way?

Thanks

Raghu

[MayilVahanan · Accepted solution]

HI

Try like this

Use Dimension limit,

- Show only

Largest - 11

And select Show others option

In Sort tab,

Sort by

Y- Value -> descending

Hope it helps