Hi Mike1024,

"how do I display 5000"? ... well in my example I display 54977 .. maybe I should have written 54977 instead of 5000.

I hope you got the idea.

Hi gorr-688214,

In my example I used Rank() because the ContactId is not unique and I want to count the unique number of them.

If you have no grouping clause then yes, you can use Row_number().

Enjoy!