Can any one please help in finding an approach to drill through to another report based on the values that are there in matrix visual.
Scenario: I have a matrix visual in one report (say Source report) in below format.
| Project Manager | Funding Project | October | November | December | January | February | March | April | May | June | July | August | September |
| ABC | 1234 | $1,500 | $900 | $790 | $1,350 | $790 | $900 | $790 | $790 | $1,350 | $1,350 | $1,350 | $1,350 |
All the months are calculted measures and now when I drill through by clicking on the value of october month, it sholud take me to another report to display all the other details that are associated to that particular Project Manager, Funding Project and that particlaur month (October (i.e. $1500) )
The other report should look in this format.
Output:
| Category | SubCategory | Sales |
| Accessories | Pedals | 400 |
| Accessories | Tyres | 600 |
| Clothing | Shirts | 500 |
Thanks,
Kalyan
