Hi,
I am creating a Pie chart showing Top 5 Manufacturers and rest all combined into 'Others'. So Mfr 1,2,3,4,5 and Others.
I want to sort the Top 5 Mfr in descending order of Sales and Others at the end.
3 answers
Hi @Ashish Nandivadekar
Like this?
I've created a Top 5 set based on State:
Now we can create a calc to show State name, or "Other" when not top 5...
IF [Top 5 States] THEN [State] ELSE 'Other' END
And another that only returns sales for top 5. Top 5 State Sales or 0. we'll use this for sorting...
IF [Top 5 States] THEN [Sales] ELSE 0 END
The sorting:
Workbook attached so you can take a look!
Let me know if it helps.
Ta, Steve
