Dragging a Cell Link based on a Pivot Table Doesn't Work

[BrianExcel]

Hello -

I have a pivot table that is laying out certain data.

I need to present that data in a little more structured format, so on another sheet, I am referencing the data in the pivot table via = and then linking to the data in the table itself.

Here is the problem - when I do the first cell, it works fine. BUT, when I try and "drag" that reference down, it only continues copying the values present in the first cell.

It's almost as if the values have been set to absolute with $ signs, (as in $A$4), but there are none.

Can anyone let me know how I can set the formula, data or table so when I drag it, it copies the next value down in the range, rather than the same one over and over?

I can go in and fix manually, but there are a lot of dates to work with and long-term it will not be practical.

 

[BrianExcel]

I found the solution...it's a bit tricky to find given how picky you have to be with your words on google...which is funny, since it's on this website....but here is the link. Ultimately, it's just a checkbox in the Pivot "Options".

GetPivotData | Excel Pivot Tables | Why Does Excel Keep Inserting GetPivotData