You can't manipulate the actual pivotcache data.
But....maybe this is an option...

If you double-click a pivot table calculated value (from the far right column
of the pivot table), Excel will insert a new sheet in the workbook that
contains all of the data behind the dbl-clicked value.

Using your posted example:
Double-click the Grand Total for East.
Excel inserts a new sheet with 65501 rows of backup data.
Then you (or your user) could move that sheet into a new workbook and
create a new pivot table based on that sheet.

Is that something you can work with?