January 26, 2021
I have two pivot tables, they both contain some matching data. I'm trying to use the GETPIVOTDATA formula to pull through a date from one of the pivots to a cell adjacent to the other. If you see on the attached sample, I'm trying to get the "Contract from" and "Contract to" date from the pivot on the "Contract Length" sheet to appear adjacent the corresponding record on the "Contract Payments" sheet.
So, in cell K3 on the Contracts payment sheet, the data should read: 1/4/19; L3 would be: 31/03/21.
The sheets I want to use the formula on are a lot bigger so it's impractical to do it manually.
I'm on a PC using Excel 2016
Thanks for your help
July 16, 2010
Welcome to our forum. GETPIVOTDATA only references value field. You need to move the From and To fields in the Contract Length PivotTable to the values area. Change the aggregation to Max instead of Count and then format the field as a date.
Then you can reference them from the Contract Payments sheet using GETPIVOTDATA .