

December 8, 2017

Hello Frans;
Good Morning
In 2 worksheets - Workbook attached , on Sheet 1 , copied entire data from another workbook , and copied GETPIVOTDATA formula for
Jan-16 & entered E12, received correct answer, but on adjacent worksheet - Piv. Tab - group by months, entered GETPIVOTDATA formula &
pointed at H13, unfortunately, getting Mar - 00. Can you please explain me in detail what I am doing wrong?
Thank you very much.
Have a great day.
Sincerely;
Mitul.

VIP

April 21, 2015

Hi Mitul, this is Frans 😉
Two things on this example, but you're almost there!
1) Your reference to cell H13 is not correct. This has to be a reference to the beginning point of the Pivot Table. If you for instance in M10 want the correct result, you can give there the equal sign ('=') and then point to H13. You will see in the GetPivotdata formula that the beginning is $D$10. This is important otherwise other formula's won't give the right results!
2) A tricky one: your cell formatting in column M is to date or adjusted (don't know what the English Excel expression is, work here with the Dutch version). When you change this in number, you'll get the right answer!
Hope this clears everything up for you?
Frans
1 Guest(s)
