Is this possible with Cross Table ??

Fri, 03 Feb 2012 22:51:36 GMT

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 — Sat, 04 Feb 2012 23:58:41 GMT

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;