Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help with drillthrough

  The late column in the data source can be either 1 or 0,    I want to know if its possible to drillthrough on the summarized values in the matrix and have the child page show only the record...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. 

 

 

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. 

 

At the same time, if I were to drillthrough  from the Total column and Central Row, the details page should display all 131 records from the central region. 

 

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. 

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous do you have "Keep all filters" = "ON"  on drill thru page.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can't turn it off if you put a numeric value in the drillthrough. 

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous sorry not sure what you mean, based on your requirement you need "keep all filters = ON" on drill thru page.

       

      Did you tested it?. Is it working?