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