Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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