Help with counting portal records
I have a layout with a portal in it. The layout is called: Payroll and i set up a relationship with Payroll and another layout called: SALES. When you enter the Sales Rep name it gives you all the sales made within a given date range. The problem is the Sales Rep can have over 60 + records (SALES) in the given date range and i need a calulation field to cound the number of records that populates when give the start & end date ranges.
My question is, is there a calulation or a way to have a field give a count of records that populate in a portal? I tired count (Table: SALES) but it gives me a total count of all his/her records not within the start & end date range.