Pivot table conditional average

[mateoc15]

I have a column that is a count of all records (count). I have a column that is the sum of a bit field (1 or 0). I have a column that is an average of that bit field (percentage). I have a column for a total dollar amount (sum). I have a column for the average of that dollar amount, which, for some reason, only gives an average where the bit field is 1. What I need is an average of that dollar amount REGARDLESS of the value of the bit field. Filtering really doesn't work because I need to be able to show both types of average. Any ideas?

Thanks!

- Matt

[tuph]

It would help us analyse the problem if you attached a sample of your workbook. Remember to replace any sensitive or confidential data before uploading. To see attachment options in you post click on <Go Advanced>.