Need help with drillthrough

Question

&nbsp;The late column in the data source can be either 1 or 0,&nbsp;&nbsp;I want to know if its possible to drillthrough on the summarized values in the matrix and have the child page show only the records for which late = 1.&nbsp;&nbsp;

timko92 · Answer

Hi there,&nbsp;I am not sure you can achieve this with the drilldown alone. However, you can make a filter for the field "Late" and filter that filter for a value of "1" when drilling down the table.&nbsp;The filter can either be implemented on the righthand side panel, or as a slicer in the report itself. If it is a slicer, you can make it impact only that table and no other visuals.

parry2k · Answer

Anonymous seems like you want to drill thru to another page (let's call it detail page) and you want detail page to be fitered only where value is 1, in this case you can set page level filter for detail page and once you drill thru into this page from main page, it will only show records where value&nbsp; is 1

anonymous · Answer

That won't solve the problem. The detail page should show all records unless I drillthrough. For example if I were to drillthrough on delivered, it should show me all the records that have the given origin.&nbsp;

parry2k · Answer

Anonymous so you are saying user can go directly to "drill thru page" and in that case you dont want to filter the page. If that is the case than you have to rethink your solution, you probably want to hide your drill thru page and only usable thru drill-thru

anonymous · Answer

Currently, I drillthrough to the details page from multiple tables/charts, so I want to be able to filter the details page based on different criteria depending on where I drillthrough from.&nbsp;&nbsp;&nbsp;For example, if I were to drillthrough from the Late column and Central Row, the details page should only show the two records that match that criteria.&nbsp;&nbsp;At the same time, if I were to drillthrough&nbsp;&nbsp;from the Total column and Central Row, the details page should display all 131 records from the central region.&nbsp;&nbsp;The issue I'm having is that even if I drillthrough on the Late Column, I see all 131 records instead of the two late records.&nbsp;

Forum Discussion

Need help with drillthrough

9 Replies

Related content

Drillthrough Help

Can bookmarks filter a drillthrough page without losing drillthrough context?

Need help with drillthrough

DrillThrough filter direction

Drillthrough Filter