Hi all,
I have a sheet with data that is constantly being updated with football results, new rows are added with data after the completion of each fixture. I then have a pivot table with the home teams as the row and averages for that team over the whole data set. What I want to do is to keep this format, but instead of using the whole data I want to have the pivot table only use data from a rolling last 10 entries for each team. I can't figure out how to do this though without doing it via a very manual filter method. Can anyone help please?
Thanks for any help!
I have a sheet with data that is constantly being updated with football results, new rows are added with data after the completion of each fixture. I then have a pivot table with the home teams as the row and averages for that team over the whole data set. What I want to do is to keep this format, but instead of using the whole data I want to have the pivot table only use data from a rolling last 10 entries for each team. I can't figure out how to do this though without doing it via a very manual filter method. Can anyone help please?
Thanks for any help!