I am using CMSUSERID & RESOURCEID. based on that I need to count as described in the image.
Currently, It is giving me a total count of 1(min) which should be the total count(i.e. 1+1+5+11+2+3+1+2…).

@Max your calculated field gives me a total count of 1520. I need the total no of distinct resources launched by district users. So, if you see in the below image and example.

User1 - 9e4 (1),
User2 - 538 (1),
User3 -

538 (1),
b48 (1),
c22 (1),
c2e (1),
f5c (5 times attempted, but as it is unique I need to count it as 1)

---- subtotal should be 5 ----
User4 -

ba8 (2 times attempted, but as it is unique I need to count it as 1)
c227 (2 times attempted, but as it is unique I need to count it as 1)

manage the count in one calculated field means, I need to divide that count(533) by total user attempted resource count(1520). So, the as a final output I need the value in percentage.

So, If I use the #test1 with cmsuserid then it is giving me total count as 533. But I need that count without mapping the calculated field #test1 with cmsuserid.