Visualizing data with hierarchy

[Anonymous]

Hi all,

I have ticket data with hierarchy taht I would like to show in a table type of format with drill down capability in a way that each row would show the details of that particular item, not any kind fo summary.

The source data is like

ID	Title	Team	Sprint	Hierarchy
1	Title1	Team1		1
2	Title2	Team2	Sprint2	1|2
3	Title3	Team1		1|3
4	Title4	Team2	Sprint1	1|3|4
5	Title5	Team1	Sprint2	1|3|5
6	Title6	Team6	Sprint1	1|3|6

And would like to present it something like this

I have tried to use Matrix but it summarizes the data for thie top level in a way that the top level rows are not showing their own data but instead the data from the first sub item.

Any ideas how to do that with Matrix or any other visual I should use?

[lbendlin]

Matrix should work, worst case you'd need some custom measure for the value well.

What you cannot do is have the ID column in the front.