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.
<colgroup><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>
Sum of Value | Date | |||||||
TL | Price | Grade | Customer | Total Costs $/ton | 12/3/2018 | 12/4/2018 | 12/5/2018 | 12/6/2018 |
BENWOOD - CIG | $50 | 100M | HALLIBURTON | $15.83 | 560 | 560 | 560 | 560 |
CHEYENNE - GRANITE PEAK | [Hold] | 2040 | SCHLUMBERGER | $12.34 | 385 | 385 | ||
FAIRMONT - TRANSFLO | $50 | 100M | HALLIBURTON | $12.34 | 200 | 200 | 200 | 200 |
FAIRMONT - TRANSFLO | $53 | 3050 | HALLIBURTON | $12.34 | ||||
MCKEES ROCKS - MRIE | $53 | 3050 | HALLIBURTON | $12.34 | 220 | 220 | 220 | 220 |
STEUBENVILLE - TIDEWATER | $55 STEUB | 4070 | HALLIBURTON | $15.83 | ||||
TYLER DIRECT | 4070-SP | VALENCE | #N/A | 400 | 400 | |||
TYLER DIRECT | [Hold] | 100M | SCHLUMBERGER | #N/A | 428 | 428 | ||
TYLER DIRECT | [Hold] | 4070-SP | SCHLUMBERGER | #N/A | 1442 | 1442 | ||
WASHINGTON - MRIE | P1 [Hold] | 4070 | UNIVERSAL | $0.00 |
<colgroup><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>