Main Label in Pivot Table - Doesn't Fill - Need to use Formula - Help?

[tarnold99]

I ran a query from our CRM and exported to Excel. You can see that we see the prospects by Sales Person. For some reason, the grouping under sales person, while pleasing to the eye - is giving me fits when I run a formula against it. So, for example, on the next sheet I might want to show the number of oppunities for Adam, that are 50% or greater and it might be:

=COUNTIFS('All Open'!A3:A3493,"Adam Hahn",'All Open'!C3:C3493,"<50")

But - the formula will return either 1 or 0 depending on what happens to be in that first row with his name in the RSD column.

Because I have it set as a dynamic spreadsheet and using a pivot table, I can't just copy down the next 10 or so rows. I want to make this something I can run again and again.

Any idea how to tell it not to group those under the rsd??

Tom

[tarnold99]

Now there is a Screen Shot attached. Please use that so my question makes more sense.

Tom