I am currently trying to produce a grouped bar graph, with 2 dimensions - Club and Player, and the expression being their salaries.
1) I want the bar graph axis to only show the Players which are at each Club, and not show every Player for each Club. I've attached a sample below ideally I want it to show for Man Utd three options Rooney, Ibrahimovic and Pogba, and not have Aguero, De Bruyne, Silva, Alexis and Ozil. Is this possible?
2) If i wanted to limit the graph to say the top 2 salaries (by Player) do I have to do this using set analysis as a calculated dimension and use the rank function?
Many Thanks