I feel I’m getting close - thank you to all who are helping, but still have issue:
I’m using this in my totals table, pulling from the registry table:
=SUM(SELECT(Medical Needs Program Registry PENDING[# dogs], TRUE=[_THISROW]))
The expression test returns the correct value - 13, but it’s not updating my sheet or the correct column # dogs.
do i need to put [_THISROW].[# dogs]