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

# Dynamic grouping of number of rows

Hi,

Can anyone help me with the following visualization.

If my data is structured in the following manner.

 Client Team X TeamA X TeamB X TeamB X TeamC Y TeamA Y TeamA Y TeamA Y TeamB Y TeamB Y TeamC

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.

Arjun

• ###### 2. Re: Dynamic grouping of number of rows

Thanks a lot Ville, this trick works.

• ###### 3. Re: Dynamic grouping of number of rows

Hi Ville,

The main problem still is that I am unable to label the complete bar as 2 or 4. In this example we can make it out from the y axis but it again gives a rough estimate if we scale the problem. Is there a way to label the bar?

• ###### 4. Re: Dynamic grouping of number of rows

Hi Arjun,

I almost got frustrated...but it was quite easy trick. I will post it here soon.

Ville

• ###### 5. Re: Dynamic grouping of number of rows

Thats good, cause I had given up.

• ###### 6. Re: Re: Dynamic grouping of number of rows

Never give up

• ###### 7. Re: Re: Dynamic grouping of number of rows

Really thanks for the effort...The trick is great...dint think in this direction.

• ###### 8. Re: Dynamic grouping of number of rows

No problem, it's always nice to find new ways how to do things.