analyzing pivot table

[ammartino44]

Hello. I have a pivot table with years (1-7) and a column B that returns a 1 or a 0. I have done a count totals on column B, which is essentially inputs with non-zero values. I would like to add another field to values, and show an average of, but I'd like it to only show the averages for values of 1 in that first column. Does that make sense?

[Glenn Kennedy]

Please post a sample of your sheet, so that we can see what's going on.