southcali12
New Member
- Joined
- Sep 22, 2015
- Messages
- 28
Hi,
I am trying to use the GETPIVOTDATA formula to fill in the table below:
<tbody>
</tbody>
My pivot table looks like such:
<tbody>
</tbody>
The formula I have written is:
=GETPIVOTDATA("Sales",$A$3,"Date",H1)
So for example $A$3 is where the Date is located in the pivot table and H1 is the date.
Any advice would be greatly appreciated. Thank you!
I am trying to use the GETPIVOTDATA formula to fill in the table below:
Date | 12/7/2015 | 12/8/2015 | 12/9/2015 | 12/10/2015 | 12/11/2015 |
Sales |
<tbody>
</tbody>
My pivot table looks like such:
Date | Sales |
12/7/2015 | 300 |
12/8/2015 | 120 |
12/9/2015 | 150 |
12/10/2015 | 500 |
<tbody>
</tbody>
The formula I have written is:
=GETPIVOTDATA("Sales",$A$3,"Date",H1)
So for example $A$3 is where the Date is located in the pivot table and H1 is the date.
Any advice would be greatly appreciated. Thank you!