The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

GETPIVOTDATA formula usage

GETPIVOTDATA formula usage

0
Votes
1
Answer

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 Answer

365 Team
0
Votes

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

×
Online Data Science Training
SAVE 60%