Forum Discussion
sconway1985
Sep 27, 2021Brass Contributor
Using GETPIVOTDATA To fill separate sheet based on dynamic data tied to dates
Hello, I have been attempting to get my data in a table to correspond with the dynamic data in a pivot table that is on a separate sheet within the same workbook. The problem is I can't get t...
- Sep 28, 2021SergeiBaklan
I figured it out
=GETPIVOTDATA("Min of Effluent_x0020_Meter_x0020_Start",Sys.PVOps!$B$3,"Date1_asdate",[@Date])
allows me to perform the function I wanted.
Thanks for your help
Best
sconway1985
Sep 28, 2021Brass Contributor
I'm just trying to figure out what I need to do with the provided formula to make it continue to reference the pivot table's consecutive dates and fields associated with them.
sconway1985
Sep 28, 2021Brass Contributor
SergeiBaklan
I figured it out
=GETPIVOTDATA("Min of Effluent_x0020_Meter_x0020_Start",Sys.PVOps!$B$3,"Date1_asdate",[@Date])
allows me to perform the function I wanted.
Thanks for your help
Best
I figured it out
=GETPIVOTDATA("Min of Effluent_x0020_Meter_x0020_Start",Sys.PVOps!$B$3,"Date1_asdate",[@Date])
allows me to perform the function I wanted.
Thanks for your help
Best
- SergeiBaklanSep 28, 2021MVP
Great to know, thank you for the feedback. I misunderstood you - I though you'd like to use dates range returned by PivotTables, not predefined manually dates in column.