I am working with email data. There are columns with dollar amounts and percentages. I am attempting to average a column of percentages within a pivot table. Unfortunately, the cells in the pivot table are blank.
I can sum and count dollar amounts in the pivot table but when I try to average, sum, etc. the percentage column (open rate for emails), I get no result.
Am I missing something?