I have a 12 months data for many companies, now i want to create a line chart that showing Top 10 companies when sorted with the latest month data, and 1 constant company and rest of all the companies in one lines as others, can any one help with this, any help will be appreciated
Can you use the Dimension Limits tab of the chart properties to restrict the displayed values to the top 10 (based on the first expression) and then tick the box below for Show Others.
PFA, file as u see there are many countries in it, i want only top 10 countries and if australia is not in top 10 then a seperate line for australia and rest of the countries in a single line as others
.png "Luminary Alumni"){kind=icon}