Drill Down & Funnel Chart

[#1]

Dear All,

Please find the attached excel as sample data.

I have a requirement where columns (C to J) i.e. from Interview -> Gamma need to be Grouped as GroupName called Stages.

Need to show the drill (Aplha->Beta->Gama-> Class Name) in a chart, i.e. drill (Aplha->Beta->Gama-> Class Name) as Dimension and

show the count of Levels for Alpha/Beta/Gamma like Count({<Alpha={'Y'}>} Levels) etc.

Also need to a funnel chart for the Stages with Class Name drill down showing the count of Levels for respective Stage element.

Pls provide a sample how we can achieve this requirement.

Thanks in advance,