Hello @land_of_bi, welcome to the QuickSight community!
While clicking on different columns couldn’t exactly navigate a user to a different report, unless the field value is actually a URL, you could set up 2 URL actions with the Menu option, that could allow the user to navigate to one of the links.
You could even name the actions in a way that would relate to the 2 columns, so it would seem related to the selection they made.
Hello @land_of_bi, since we have not heard back from you with any follow-up questions, I will mark my previous response as the solution. Please let me know if you have any remaining questions on this topic and I can guide you further.