Thread: Pivot Table Averages based on Unique Values

I've searched for an answer and could not find one that fit my situation.

I am working with a pivot table and I need to add an average column based on data that has been created by the pivot table. Attached you'll find my sample spreadsheet.

I have different "Types" of data that I'm trying to identify and based on the Type, I'm want to know the invoice totals, and then the average for that type based on the number of unique invoices. I can't use the simple Average function in the pivot table because each invoice has multiple lines and it does the average based on the number of lines total and not on the number of unique instances.

That being said, is there a way to add a column to the spreadsheet that would be dynamic that would take the total invoice number by Type and do the average based on # of unique invoices? I've given some direction in the spreadsheet to make things a little more clear.

Doh... here is the attachment...