There are a couple of different ways you can do this. Probably the easiest would be to use running totals. You'll create two of them - one for each status you want to count. You'll configure it like this:

Running Total Name: Give it a name.

Field to Summarize: If you have one, I would use an ID field of some sort here - something that is unique to the detail record.

Type of summary: distinct count (or just count if you don't have anything unique in the record.)

Evaluate: Use a formula. The formula would look like this:

{MyTable.StatusField} = 'Pending'

Reset: On change of group - the group where where you'll put the values in the footer.

If you need both group-level totals and grand totals, you'll need to configure separate running totals for each.

-Dell