@ timiop2011. I'm not sure what you are talking about haha. How does that relate to a pivottable?

@estige. I'll try that out. It's interesting that when you apply that filter it impacts the row instances as well. For example, it only shows the rows that have that value that you filtered on. For example, customers are in rows, type of sales is in values (discount, normal). When I click on filter to normal, it only shows contracts with at least a 1 count for normal, whereas when you have all it shows all contracts even if they didn't have a sale.

Thanks.