I want to calculate an average for the value Ist_Pk for each [Masch.-Nr.] but it does not work.
I tried to combine Rank and Aggr function to first rank the the field "Woche" because this contains the information about the date. this means the highest 4 entries for each [Masch.-Nr.] should be Aggr. to an avg of Ist_Pk.