The best way to show counts of the receivables in column C in the pivots is to: Add another instance of Amount to the pivot tables with the appropriate field value settings and formatting Determine the counts with the count() function in the receivables sheet and reference them in the pivots sheet Counts cannot be added reliably because they would change with different data for Customer, CreditDate, and Amount Counts would be undesirable because they would replace values showing as Sum of Amount in the pivot tables