I am using the following formula to bring in data from a table but I am getting a reference error. =Getpivotdata("Value",Pivot absolute reference,"Date",cell reference A date,"TL",cell reference a TL" Here is my pivot table. Any help would be greatly appreciated.
[TABLE="width: 915"]
<colgroup><col><col><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Sum of Value[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TL[/TD]
[TD]Price[/TD]
[TD]Grade[/TD]
[TD]Customer[/TD]
[TD]Total Costs $/ton[/TD]
[TD="align: right"]12/3/2018[/TD]
[TD="align: right"]12/4/2018[/TD]
[TD="align: right"]12/5/2018[/TD]
[TD="align: right"]12/6/2018[/TD]
[/TR]
[TR]
[TD]BENWOOD - CIG[/TD]
[TD]$50[/TD]
[TD]100M[/TD]
[TD]HALLIBURTON[/TD]
[TD]$15.83[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[/TR]
[TR]
[TD]CHEYENNE - GRANITE PEAK[/TD]
[TD][Hold][/TD]
[TD]2040[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]$12.34[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]385[/TD]
[TD="align: right"]385[/TD]
[/TR]
[TR]
[TD]FAIRMONT - TRANSFLO[/TD]
[TD]$50[/TD]
[TD]100M[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]FAIRMONT - TRANSFLO[/TD]
[TD]$53[/TD]
[TD]3050[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCKEES ROCKS - MRIE[/TD]
[TD]$53[/TD]
[TD]3050[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[/TR]
[TR]
[TD]STEUBENVILLE - TIDEWATER[/TD]
[TD]$55 STEUB[/TD]
[TD]4070[/TD]
[TD]HALLIBURTON[/TD]
[TD]$15.83[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][/TD]
[TD]4070-SP[/TD]
[TD]VALENCE[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][Hold][/TD]
[TD]100M[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]428[/TD]
[TD="align: right"]428[/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][Hold][/TD]
[TD]4070-SP[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1442[/TD]
[TD="align: right"]1442[/TD]
[/TR]
[TR]
[TD]WASHINGTON - MRIE[/TD]
[TD]P1 [Hold][/TD]
[TD]4070[/TD]
[TD]UNIVERSAL[/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 915"]
<colgroup><col><col><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Sum of Value[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TL[/TD]
[TD]Price[/TD]
[TD]Grade[/TD]
[TD]Customer[/TD]
[TD]Total Costs $/ton[/TD]
[TD="align: right"]12/3/2018[/TD]
[TD="align: right"]12/4/2018[/TD]
[TD="align: right"]12/5/2018[/TD]
[TD="align: right"]12/6/2018[/TD]
[/TR]
[TR]
[TD]BENWOOD - CIG[/TD]
[TD]$50[/TD]
[TD]100M[/TD]
[TD]HALLIBURTON[/TD]
[TD]$15.83[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[TD="align: right"]560[/TD]
[/TR]
[TR]
[TD]CHEYENNE - GRANITE PEAK[/TD]
[TD][Hold][/TD]
[TD]2040[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]$12.34[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]385[/TD]
[TD="align: right"]385[/TD]
[/TR]
[TR]
[TD]FAIRMONT - TRANSFLO[/TD]
[TD]$50[/TD]
[TD]100M[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]FAIRMONT - TRANSFLO[/TD]
[TD]$53[/TD]
[TD]3050[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MCKEES ROCKS - MRIE[/TD]
[TD]$53[/TD]
[TD]3050[/TD]
[TD]HALLIBURTON[/TD]
[TD]$12.34[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]220[/TD]
[/TR]
[TR]
[TD]STEUBENVILLE - TIDEWATER[/TD]
[TD]$55 STEUB[/TD]
[TD]4070[/TD]
[TD]HALLIBURTON[/TD]
[TD]$15.83[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][/TD]
[TD]4070-SP[/TD]
[TD]VALENCE[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][Hold][/TD]
[TD]100M[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]428[/TD]
[TD="align: right"]428[/TD]
[/TR]
[TR]
[TD]TYLER DIRECT[/TD]
[TD][Hold][/TD]
[TD]4070-SP[/TD]
[TD]SCHLUMBERGER[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1442[/TD]
[TD="align: right"]1442[/TD]
[/TR]
[TR]
[TD]WASHINGTON - MRIE[/TD]
[TD]P1 [Hold][/TD]
[TD]4070[/TD]
[TD]UNIVERSAL[/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]