1 Reply Latest reply on Nov 14, 2018 9:55 PM by Shinichiro Murakami

    Dynamic Grouping

    Richard Massey

      Hi all,

      I have a dataset which contains 2 columns (amongst a bunch of others) that I want to dynamically group on:

      •      Contractor Name
      •      Recommended Contractor

       

      An example of the data (filtered for Contractor Name = Name 1) within the set could be:

       

      Contractor Name
      Recommended Contactor
      Name 1Name 2
      Name 1Name 1
      Name 1Name 3
      Name 1Name 1
      Name 1Name 1
      Name 1Name 2

       

       

      At the moment, my output looks like this:

      Recommended Contractor
      Name 1
      Name 13
      Name 22
      Name 31

       

      What I would like it to display is the following:

       

      Recommended Contractor
      Name 1
      Name 13
      Other3

       

      My dataset contains several thousand rows - therefore the need for grouping the others together.

      I need it to work dynamically as the main filter for the dashboard is Contractor Name.

       

      Can anyone help?