1 Reply Latest reply on Aug 19, 2016 11:20 AM by Adam.Cogswell

    How to build dynamic group based on the contribution to the total value

    Deepak Nandi

      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