Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Drill Through from a Matrix

Hey all,

 

Im trying to create a Dynamic Drill Through from a matrix.

this is my sample data:

 

NameCategoryValue
Name_01Cat_0135
Name_02Cat_023
Name_03Cat_0333
Name_04Cat_0138
Name_05Cat_0234
Name_06Cat_0336
Name_07Cat_012
Name_08Cat_0228
Name_01Cat_0229
Name_02Cat_0338
Name_03Cat_0149
Name_04Cat_0221
Name_05Cat_0314
Name_06Cat_0116
Name_07Cat_0246
Name_08Cat_0125

 

And the matrix looks like that:

 

Every category(Cat_01,02,03) has it's own Drill Through, which means I have 3 drill throughs. 

How can I choose a name, a category and then move to the attributed drill page?

I know there is 2 ways:

- Choose a name, a category -> left click -> Drill throgh -> Choose the drill through page

- Insert WEB URL in a conditional formating, but when you press on the number, it's opens the right page, but without the name and category you chose, and it loads the page instead of just applying it as filters.

 

Any other ways?

Thanks!

5 Replies