I have a simple problem with Tableau I am not able to solve.
I would like to display a graph showing a measure over time. I would like to compare one client that the user selects through a parameter to all other clients not selected. The graph would display two lines with 2 different colors: one for the selected client, the other line for other clients. The idea is to have a benchmark.
However I would like to filter the other clients with a condition like: if vertical(other clients)=vertical(selected client) then vertical(other clients), meaning that I would like only to keep the clients that have the same vertical than the selected client. This in order to avoid the user to filter manually by selecting the vertical of the selected client.
Is it possible to do that? if yes, please let me know how!
Many thanks for your help!