Forum

Notifications
Clear all

Cannot get correct result from GetPivotdata formula

2 Posts
2 Users
0 Reactions
147 Views
(@mitulpar1964)
Posts: 64
Estimable Member
Topic starter
 

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.

 
Posted : 01/05/2018 7:44 am
(@fravis)
Posts: 337
Reputable Member
 

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

 
Posted : 01/05/2018 3:45 pm
Share: