Forum Discussion
Insert COUNTA as a calculated field (pivot report)
Hello, I need help to insert a calculated field in a pivot report where the field counts notblank cells (see Number of yrs not blank). The point is to know for each donor how many years they have giv...
Thank you. My original list is a vertical list of 42,000 name, date, gift hence the pivot.
Elva_Tanguerre Then I would go for the Power Pivot solution.
