Pareto Chart with multiple level

[york]

Hi Guys：

   I have raw data like below, I want to create a pareto chart with below data, and the X axis is the Defect level 1 and defect level 2, I hope the two level can be drilled, and the Y axis is the qty of the defect, I tried but my chart can't be drilled, could you tell me how to make it?

Defect Level 1	Defect Level 2	Supplier	Defect Qty
A1	A	Apple	1
A1	A	Apple	1
A2	A	Apple	1
A3	A	Apple	1
A4	A	Apple	1
B0	B	Apple	1
B1	B	Apple	1
B1	B	Apple	1
B2	B	Orange	1
B0	B	Orange	1
C1	C	Orange	1
C2	C	Orange	1
C1	C	Orange	1
C0	C	Orange	1
C1	C	Orange	1
A1	A	Orange	1
C2	C	Pineapple	1
B3	B	Pineapple	1
B2	B	Pineapple	1
B0	B	Pineapple	1
C1	C	Pineapple	1
C2	C	Pineapple	1

[Dhairya]

You can use "drill down combo" or "drill down combo pro" of zoom charts from get more visuals.

Please mark my solution as accepted if it helped you!

[york]

Hi Dhairya:

   Thanks for your reply, and I think the chart can meet our requirements, I may need to create some measures to create the pareto chart.

[Dhairya]

yes you have to create mesures as per requirements and plot them in required heirarchy.

Please mark my solution as accepted if it helped you!
Thank you!