Hello,

Thats the question, I have a pivot that I want to count the total number of
unblank fields, there are about 10, but it takes the sum and shows like 300
in grand total. I need the grand total to say 10. Is this possible? I need
this because of data replication.