count of projects within user access
I have a list of projects that is in selective access. I need to be able to get the count or number of projects per user. For example user A has access to 1 project. Total count of projects is 4.
When I do a count line item (formula = 1 ) my line item result if 4 even if I only have access to 1 project. How will I be able to get the to get the result or 1 for the count. See screenshot below :