Hi all,

I have created a report that shows the collections per client within a certain period. This period is determined by 2 parameters. Next, I only show the top 30 clients based on their collections. And at the bottom, I showed the total collections of all the clients.

Now my question is, how can I calculate the collections of only the top 30 clients? I want to see the collections from our top 30 clients against the total collections.

I was thinking about ranking the clients each time the report is created. This way I could just say add rank 1 till 30. But how can I do this? Anyone has any ideas?

Thanks in advance.

Kind regards,

Gerben

I fixed it by using a running total. This way he only uses the clients that are shown on the report.

I did the second option. I checked it by manually calculating all 30 records, and the numbers matched. But thank!