Forum Discussion

sconway1985's avatar
sconway1985
Brass Contributor
Sep 27, 2021

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...
  • sconway1985's avatar
    sconway1985
    Sep 28, 2021
    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

Resources