Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
I