I'm trying to build a report but I'm facing a challenge to develop a specific visual.
Given this data example:
|Product name||Product ID||Manufacturer|
I'm trying to drillthrough from a matrix with above information, based on Product ID, and once I drillthrough I was trying to show all rows that are of the same Manufacturer.
Let's say I drill through on Product ID 2, that has manufacturer AAA, I was expecting to see on this new matrix, only products from manufacturer AAA, and not only the information of Product with ID 2. How can one achieve this? If not doable using drillthrough, how could someone could show all the manufacturer products related with the Product ID that is selected on another visual?