help with avarage per etappe per office
hello i need some help with a average formula i have a data sheet that looks like this: ETAPPE OFFICE Naam Punten 1 Zwolle Roy 30 1 Deventer Wouter 25 1 Zwolle Roy 26 1 Zwolle Petro 28 1 Deventer Wouter 24 1 Deventer Ivo 20 ETC ETC ETC ETC So i need a average per Office of the punten that i can use a slicer with the etappes i placed a screenshot of dashboard that you can see how i want to use it. so in the tabel that has a red line i want the punten to be a avarage of the total points from that office so if zwolle has 2 people and score 90 points in etappe 1 the avarage must be 45 points in etappe 1 etc etcdax formule for ranking
hello i need some help to get a ranking based on colum of points i have a colum of points where i use the sum function on so i get a total of points per person now i want a ranking on that slike this 1. person 1 50 2. person 3 40 3. person 2 38 i also placed a screenshot of the data i the colum punten are the points that i use and i the colum name are the names of the person that need the ranking based on the columm punten i hope someone can help
