Activating drillthrough only on specific pages

[Anonymous]

Hi everyone,

Is there a way to decide that drillthrough on a certain page has to be activate only where I want it to? I'll explain myself with an example:

Let's say I have 3 pages:
Page 1 that has a bar chart with sales amount by product category
Page 2 that has a bar chart with total cost by product category
Page 3, hidden, that has a table with all the products and that has the product category column as a drillthrough field

This means that if the user right-clicks, he can reach page 3 from page 1 and 2, because both use product category in a chart
Is there a way I can activate the drillthough from page 1 but not from page 2? 

As of now there is only one way I can think of: I duplicate the product category column in my product table and in this way I have two identical columns, one will be used as an axis in the bar chart in page 1 and as drillthrough field in page 3, and the other will be used as axis in the bar chart of page 2. In this way, they are two different columns and even though they look the same to the user drillthrough will not happen in page 2. 

However, this seems a convoluted and memory consuming process if I want to perform this operation many times for whatever reason. Do you know if there's another way? Thanks

[Anonymous]

The best you can do here is to duplicate a column and use one in drill thru and pages you need to show at drill thru & other column in pages you do not want.

[Anonymous]

@Anonymous I am also travelling in the same boat. Did you able to resolve it ?

Thanks,

Shubham

[Anonymous]

I used the method I explained in the opening post, trying to use the feature as less as possible. Unfortunately there is no other way it appears.

[parry2k]

@Anonymous As mentioned in my reply, it is not possible at this point? It is all or nothing.

[parry2k · Accepted solution]

@Anonymous Unfortunately there is no control available to not to show drill through option, I believe there is an idea on this on ideas forum and vote for it. Your best bet is what you proposed which is indeed not the correct approach and un-necessary to achieve such a small functionality. 

[amitchandak]

@Anonymous , What I know as of now if we can drill to the page and we have the drill-through parameter in the other pages then ithat page will show drill through option