Last answered:

21 Apr 2020

Posted on:

20 Apr 2020

0

GETPIVOTDATA formula usage

Hi,
After watching the EXCEL course, I would like to raise the following question:
When modifying the GETPIVOTDATA formula in order to make it dynamic within a P&L statement, why becomes necessary to copy+paste the year from the pivot table so that we can use it as a reference, instead using the year you already has as a title in the P&L table to be able to make the reference for the year?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

21 Apr 2020

0
Hi Marta, I do realize this is a bit annoying. The underlying reason is that there is an Excel bug, which Microsoft hasn't addressed so far. Best, Ned

Submit an answer