I have a pivot table that summarizes data by day.
The sample values 300 and 500 below, are calculated based on 10 values each.
Is it possible to have the same pivot table created, but instead of using 10 values, to create the average using the highest 5 values ?
Thanks!
Date Avg Val
2022-10-23 300
2022-10-25 500
The sample values 300 and 500 below, are calculated based on 10 values each.
Is it possible to have the same pivot table created, but instead of using 10 values, to create the average using the highest 5 values ?
Thanks!
Date Avg Val
2022-10-23 300
2022-10-25 500
