Drill through

...the naviagtion should take user to next page where only the further details for Product "B" is mentioned. Basically a drill through kind of an idea but for each of the records, functionality should work similarly, for that selected product. 

Go to desination page 

1. From the format Tab Expand 'Page informtaion'
2. Change 'Page Type' 
3. Click Add data to select your Products field

So the requirement is to add a functionality to the above table where- if a user wants to see further analysis of a product lets say Product "B" based on the profit/sales then they should be able to click on that specific record and ....

Right click a record of your choice in the first page then Drill through to your destination page

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated