Ok nevermind.... just realised that doesn't necessarily work.
When these new count calculation fields are placed on a layout from donor table, they display the info for that donor only. I'm looking to get an overall count for all donors.
There are several different ways to selectively count, sum, average, etc. different groups of records.
1) In a summary report, you can sort by the "category" field (your "received" or "pending" field). Put a summary field that counts/sums or whatever you need in a sub summary layout part "when sorted by category", sort your records by that field and you have your sub totals.
2) ExecuteSQL can produce the same aggregate value for a single category or a list of all categories.
3) Sorted one row portals can refer to that same summary field with a portal filter that limits the records to just those of the category.
Thanks again for your help Phil, always a pleasure.
I tried the recommended solutions without much success. Perhaps the relationships are not set up correctly in my db to properly implement your suggestions. I also don't have much experience with summary reports and since have started to read The Missing Manual to learn a bit more.
The solution I came up with, that works well for my db is to place a button on the main page which starts a script. The script performs multiple finds for the categories of interest. I then throw the Get (foundcount) result into global fields and display these numbers in a comment box. This option introduces an extra click, but I think it should be sufficient for a pseudo "inventory" of various categories.
Thanks again for your help.