Hello,
I’m working on this for days, I have this data base based on hours worked by supplier, there are over 30 supliers, but I only want to show the top 5 supliers individually by there names and group the rest into group “Others” I want to add the other 28 suppliers within the ‘Others’ group and add up the total hourly value of these 28.
Can someone help me?
Here is a picture, I’m not showing there names cause it is a job for the company I work for and it is confidential.
As you can see it is showing only the 5 top company by there names, but it is not grouping the other 28 into “others”
Hello Theodoro, you would like the top 5 that is auto generated and also by month right? if you remove the group/ color number do you see everything? Could be something in the data? I have used this visual with no problem unless you need to define your top 5. Can you see with the subtitle what is included there?
I need to rank the top 5 based on the hours worked and also group the rest into ‘Others’. I don’t know if I’m right, but I think I’ll have to use a calculated field right?
I think it should work fine within the chart you are using , I don’t see the issue there maybe would be good to see the raw data or check in a table
