Optional Hierarchy

[Anonymous]

Hello!

I am wondering if there is any way to have an "optional" tier in a hierarchy...to whit:

My "normal" scenario is Division > Team > [stats]

I have a couple of divisions that need to be Division > Group > Team > [stats]

Am I able to manage that in a matrix? Adding the field in doesn't work the way I want--it has blank values. I can't find anything online (but I may be searching for the concept incorrectly).

Thanks!

[Anonymous]

Hi @Anonymous 

You can use bookmark and button to display the hierarchy:

e.g 

If this cannot meet your requirement, can you provide some sample data or pictures?

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for the sample file! It is not quite what I need, though.

Here's a representation of my sample data. I have a file I can send, but apparently I can't figure out how to attach the file. As you can see, I have a list of people, all assigned to teams. Some of those teams have "sub teams".

My goal would be that my single Matrix could show all teams in a single view, such as:

Team A > Addie, Albert, Bob

Team B > Team 1 > Bill, Murray, Phil

Team B > Team 2 > Rob, Angela

Team C > Raquel, Max

Hopefully this makes sense. My visualization right now just has:

Team A > [blank] > Addie, Albert, Bob

I know *why* the [blank] is showing up (it's an empty field in that column) but I'm not sure how to make that empty field not be shown when it's blank, and shown when it is NOT blank.