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 given. I am new to calculated field and I tried inserting COUNTA(b2:d2) in the formula field and it won’t accept it. Thanks!

​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 given. I am new to calculated field and I tried inserting COUNTA(b2:d2) in the formula field and it won’t accept it. Thanks!    Read More

​