Pivot Table

I am using Execl 2016 with Windows 7.  I have a pivot table and i want to use one of the columns in a separate calculation.  I want to reference the data in the pivot table.  However, when I use the GETPIVOTDATA to bring that value to another column, I tried to drag that reference down the column but the data that shows up is the cell that I referenced first.  It does not change by row.  How can I do this?

By: Tony M

Leave a Reply

Your email address will not be published. Required fields are marked *