Hierarchy? Drill Down dimension? for Org chart

[Mini_Elaine]

Hi all,

I am total confused how to create org chart and define hierarchy (especially they are not really hierarchy). I have a table like below:

This table shows more than 100 products in two different warehouses with 4 sale persons. I would like to have a org chart like below: 

My table looks like the following: 

Product ID	Shipping status	Sale person	Warehouse
A	Shipped	Mary	2
B	Preparing	Mark	1
C	Preparing	Karen	1
D	Preparing	Katie	2
E	Shipped	Mark	2
F	Shipped	Karen	2
G	Preparing	Mark	1
H	Shipped	Mark	1
I	Shipped	Katie	1

Like you may notice they are not completely in hierarchy system.. How could I archive that?

Many thanks,

Min

[Aurelien_Martinez]

Hi,

With an org chart that can be tricky, but with the sankey chart your easily do that: