Question: I have a Pivot table in excel that is using a raw table as its data source. This pivot table is doing a bunch of grouping and summing of rows. 

I'd like to now use the result of this new pivot table as the data source for a new pivot table which will further modify this data. 

Is this possible with excel? I suppose you could call it 'nested pivot tables'

Answer: 
* Make your first pivot table.
* Select the first top left cell.
* Create a range name using offset:

`OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A:$A)-1,COUNTA(Sheet1!$3:$3))`
* Make your second pivot with your range name as source of data using F3.

If you change number of rows or columns from your first pivot, your second pivot will be update after refreshing pivot

GFGDT
here is how I've done this before.

1. put a dummy column "X" off to the right of your source pivot table.
2. click in that cell and start your pivot table.
3. once the dialogue box pops up you can edit the data range to include your pivot table.
4. this may require you to Refresh the source table first and then refresh your secondary pivot table...or do refresh all twice