Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to do Multi-Level Drill through With same Filter value of different tables.

Want to drill through from one page to another page with filter(Dropdown) update.

Created Three pages, 
1. Dashboard & Charts
2. Summary Table
3. Details Table.

Filter of Dashboard and summary page are same but for details page there is different column used as filter but entity(data value) are same.
Data are simillar to below image & for both datatable we have in different sheets(table).
For Dashboard & summary page already used Supplier & Is Historical as filter(Dropdown) and for details page same filter(Dropdown) applied, but for Is  Historical selected column of Details Table.

 

 

While drill down through from summary Is Historical Filter not updated for Details Page.
To make it happen aslo mapping with Column Is historical where Supplier Mapping already there.

 

Set Default Is historical = Forcasted (False) 
 Now update filter value as Historical(True) and drill through Dashboard to Summary page all working fine.

When Drill through Summary page to details page Is Historical (Dropdown) filter value remain same Forcasted (False).
How to set that filter vlaue updated as per set in summary page while drill through details page?  

 

 

Need Help
Tutorial Requests

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi v-henryk-mstf ,

      Thanks for the reply, 
      But it doesn't work.
      There are two tables, one table have summarized result supplier wise, While in other table data are at order id and product Id level.

      Order delivered before today's date consider as historical, and future delivery consider as forcasted.
      (There are no data for current year 2021, all data are for past yrs or future years)
      In summarized there is column for Delivery status (Histo / Forcst)
      that column not exist at in details table so, created column of it & create table mapping.
      For Drillthrough report representation.

      So while on Supplier's summary page check data of Historical(Select Filter value [Radio Button]) and drillthrough to details that time This Historical Filter not applied. and Displaying result of all data (List of Historical + Forcasted Orders).

      Is there any way that Filter applied to Details view page using drillthrough?