8 Replies Latest reply on Oct 15, 2013 12:48 PM by Ville Tyrväinen

    Dynamic grouping of number of rows

    Arjun Mehra

      Hi,

       

      Can anyone help me with the following visualization.

      If my data is structured in the following manner.

       

      ClientTeam
      XTeamA
      XTeamB
      XTeamB
      XTeamC
      YTeamA
      YTeamA
      YTeamA
      YTeamB
      YTeamB
      YTeamC

       

      and I need to present a bar chart -

      If client X is selcted (filtered) - show bars of 1,2 saying 1 team occurs twice and 2 teams occur once

      If client Y is selcted (filtered) - show bars of 1,2,3 saying 1 teams occurs thrice, 1 teams occurs twice and 1 team occurs once

      Can this be done?

       

      I have also attached a workbook with an example of what exactly I am looking for.

       

      Thanks in advance

      Arjun