Drill Dow On a Table chart

[ajitsahoo8338]

Activity Number	Task Name	Resource
3000	Design Start	PROJECT
3000.1	Define Phase	CONTROL
3000.1	Define Phase	ELEC
3000.1	Define Phase	FLUID
3000.1	Define Phase	MECH
3000.1	Initial Start	PROJECT
3000.1	Operator Manual	TECH COMM
3000.1	Machine Visit	ELEC
3000.1	RGI GA	MECH
3000.1	Operator Manual	FLUID
3000.1	RGX Operator Manual	TECH COMM

Hello Everyone My requirement is to create a drill option from Task Name to Resource Like If I click on any task name then it should drill down to its resources. I want the Activity Number and Task Number to be visible on the sheet all the time. Can we achieve this?

[Idrissshatila · Accepted solution]

Hello @ajitsahoo8338 ,

there's no drill down for the table chart, you can acheive this in the matrix visual.

[Anonymous · Accepted solution]

Hi, @ajitsahoo8338 

Idrissshatila is correct. 

As Idrissshatila said, there's no drill down for the table chart, you can acheive this in the matrix visual. 

First you need to select the matrix visual: 

Then drag the field Task Name into the Drill through of Visualization: 

Then click on Drill down in the matrix visualization: 

Finally, click on the Task Name to get the corresponding Resource: 

You can click Drill up to go back: 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila · Accepted solution]

Hello @ajitsahoo8338 ,

there's no drill down for the table chart, you can acheive this in the matrix visual.