Help with GetPivotData

[Gjg1234]

Hi,

I cannot seem to get all parts of my formula to calculate.

I have created the formula for 243 rows, but even though the formula is supposed to calculate correctly for all rows, it seems to work for some rows but not for the rest where it is supposed to calculate.

My formula is as follows:

Works for this:

=GETPIVOTDATA("Count of Product Code",Pivot_Analysis!$A$3,"Total No of Orders",B2,"Total no Qty Ordered",C2,"Total No of Days",D2,"Total No of Order Lines",E2,"Total No of times picked from a Pallet Location",F2)

But not this (even though it is supposed to):

=GETPIVOTDATA("Count of Product Code",Pivot_Analysis!$A$3,"Total No of Orders",B2,"Total no Qty Ordered",C2,"Total No of Days",D2,"Total No of Order Lines",E2,"Total No of times picked from a Pallet Location",F2)

Formula Sheet:

[/IMG]

Reference Pivot Table:

[/IMG]


Any ideas on how to fix this?

 

[Gjg1234]

Hi Rory,

Thanks so much for your reply,

i got this:

=GETPIVOTDATA("Product Code",Pivot_Analysis!$A$3,"Total No of Orders","Low ","Total no Qty Ordered","Low ","Total No of Days","Low ","Total No of Order Lines","Low ","Total No of times picked from a Pallet Location","Low ")

 

[Gjg1234]

Hi Rory,

Its okay, I managed to fix it. I found the error, there was a space in the 'Low' in another one of my excel sheets.

Thanks so much for your assistance!

 

[RoryA]

Looking at that, there's a space at the end of all the Lows.