Repeating Group - Pagination of API results, can't get anything to show after page 1

Hello, I’m trying to do pagination on a repeating group w/ an API call and I need to show the data based on the page # that it’s on and I can’t run any calculation on my formula because it forces me to choose the API get’s column instead of finishing my calculation. What should I do here? My results can’t show anything past the first page right now because I’m indexing off the current cell’s index to show the results, but in reality I need to do a calculation off of the page # AGAINST the cell’s index to show to actual result on the repeating group’s row.

Screen Shot 2022-08-18 at 12.49.06 PM