Is this possible with Cross Table ??

[#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,

[disqr_rm]

s this what you need?

FinalTable:

CrossTable(Stages, [Stages Value], 5)

LOAD Levels,

     [Class Name],

     Amt,

     Qty,

     Profit,

     Interview,

     Project,

     Demo,

     Pricing,

     Alpha,

     Beta,

     Due,

     Gamma;    

LOAD Levels,

     [Class Name],

     Interview,

     Project,

     Demo,

     Pricing,

     Alpha,

     Beta,

     Due,

     Gamma,

     Amt,

     Qty,

     Profit

FROM (ooxml, embedded labels, table is Sheet1);

I