Hello,
In my application, i would like to build a sheet to manage ressources, so at the top, i put a filter by ressources name.
Now i need to create a bar chart that show the utilization of all the ressources that has the same job title than the ressource selected, so this bar chart must ignore the previous filter (the name), but take into account the job title of the selected ressource as a filter.
I tried to explore the set analysis or the data handling options but i didn't find any solution.
Can anybody help ?