Forum Discussion

RRaj_293's avatar
RRaj_293
Helper III
3 years ago

Drillthrough only for selected values within a Column

Hi , 

 

I have a drill down table as below which lists the Number of orders for each fail reason which is a drill down on Fail group.

 

Requirement - I want to be able to drill through to the details of the orders which make up to the count along with its related data . Example - for Drill through on 'No Stock' - I need to include in my detail page - order and Product related information. But for the drill through of other reasons listed product information is not relevant. 

 

So I need help and suggestions(or new approach) on couple of approaches I could think of -

1. Enable the drill function only on 'No Stock' and 'Cancelled' values of the fail reason.

OR

2. Be able to switch detail report /table within detail report based on the fail reason selected , so I can show product information for 'No stock' details page and other reasons would have only 'Order' related information in their respective pages.

 

Appreciate quick responses! Thanks in Advance.

 

Fail group 
Fail ReasonOrders
No Stock890
Cancelled289
Sales193
No RepliesBe the first to reply