Thanks, this is what I was looking for. Can you please provide me with the steps what you have done.
I want to show 15 customers names and their sales.
I created a field (Set of 10) to group the records into 15 records. If you drag this field into view you will see that 1 will repeat 15 times, 2 again 15 times and so on. You can change the denominator i.e 15 to whatever number you want.
Then I used this in the filter to show the 15 records at a time using unique values like 1,2,3 and so on.
If this helps then please mark the answer correct to close the thread.