Hi,
I am new to Tableau.
We have a requirement where we have around 50 vendors which provides material to a company and out of which usually 10-15 are the primary ones and comprise 70-80% of the total amount. The rest 35-40 vendors only contribute to 20-30%, requirement is to show Vendor names for the major contributing ones and to group those small vendors into 'Small Vendor' group and aggregate their values while showing in the chart. The group should be dynamic i.e. should change based on the data, like say as per today's data one vendor may come under Small one's but in next 1-2 month that can go into major contributing vendor.
Can someone help to accomplish these please?
Thanks,
Deepak
Hi Deepak. You might be able to get where you're going with a computed set. If that's not exactly what you want, you could build a calculated field using level of detail expressions. This example would check each vendor to see what percentage of the overall material it provides, and bucket the vendors with less than 5%:
IF { FIXED [Vendor] : SUM([Amount])} / {SUM([Amount])} >= 0.05 then [Vendor]
ELSE 'Small Vendors'
END
Hope this helps!
Become a Viz Whiz on the Forums! Support the Community and master Tableau.