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]
??
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |