Count of records in nested query

Hi,
I have a nested query as below;

On the page I show the repeat of the categories and then the machine contained within each category.

I have then highlighted all those records whose archived field is equal to ‘yes’

How do I output at the top on of my page how many records are archived?

I have tried selecting the archived field in the serverconnect repeat but I can’t seem to work it out.

Many thanks
Charles