I already have the pivot table set to display zeros instead of blanks, but I need to also include them in the average. This is a rolling 10 day report that displays scores. I want to sort it by the average over this time period, but the zeros are being ignored. Can anyone help with this? Thanks