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 Reason | Orders |
| No Stock | 890 |
| Cancelled | 289 |
| Sales | 193 |
