drillthrough from summary table row help

[askme1217]

i have Orders summary table like  year, category, total_sales. I want to create a drillthrough report from the total sales number row  and see all relevant order details page.  total_sales value is coming from a measure.  if right click and drillthrugh from that row, all filters are not passed and it is showing all orders. 

1. i dont want to right click and drillthrough

2. i want to click on row value be able to drillthorugh to details page.  

is it possible to do?

[maruthisp]

Hi askme1217,

As per my knowledge, use a button with drill through action. Can you try this approach?

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X