Hi, hope someone can help.
I have a pivot table that shows number of players in a club. There are multiple teams who play on a variety of days. I would like to show a series of graphs which show results based on the filters applied (game date, team, position,player name).
I have pivot tables that counts the number of players in attendance on the selected day, but I want to show this as a percentage of ALL the players in that division (including if no-one from a division turns up).
Can this be done with either power query or pivot tables/relationships.
Thanks in advance
Bookmarks