Another way to solve the GETPIVOTDAT bug
The reason why the error occours is that the GETPIVOTDATA expects that all the parameters are formated as text. When we type 2015, for example, MS EXCEL gets it as number automatically.
Another way to solve this issue is by adding a single quotation mark before the number ('2015). This way MS EXCEL will read it as a text, not a number.
Hi Rafael,
This is awesome! Thanks for sharing. I forgot to mention it in the lesson. Makes sense.
Best,
Ned
There is another way to get rid of this issue. When we extract the Month and Year numbers from SAP imported data it comes in a text format instead of the number format, all you need to do is go to the last cell of the month first and go one cell below by pressing the arrow down key and you will be in the first black cell of the range, type 1 in that cell and copy it, after copying the cell, select all the month and year ranges that you just extracted from SAP imported data and go to paste special and check the multiply option and hit OK, this way your month and year will be converted to numbers from text.
Now you can type the years above the month headers. The formula will work like a charm.