I have a pivot table containing weekly volume data, going back four weeks. Problem is, when any one of the companies I'm tracking doesn't produce volume, there is no record in the source data. So on the Pivot table for the last four weeks I might see blank blank blank 400. I need the average in this case to be 100, not 400. Anyone know how to solve this? Thanks in advance. Summarize Values By Average Summarize Values By Average
