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.
Or will I have to go the calculated Dimensions way?