Paging in the pivotGrid is badly needed when working with anything but the most trivially small datasets.
The display can be paged in both directions according to the row and column headers.
The XMLA properties BeginRange and EndRange will perform the paging.
You can calculate appropriate values and page boundaries from the number of members in each dimension.