GETPIVOTDATA problem with two matching fields
Posted by Mark Jeanes on September 27, 2001 11:14 PM
Say you have two columns down the left hand side of a pivot table - a customer number and part number. Let's say that sometimes a customer number just happens to be the same as a part number, even though they are not related.
How do you use getpivotdata to pull off the amount that combination?
custno partno amount
301 456 $567
302 456 $235
How do i get the amount for 301(custno) and 301(partno) (e.g. $432)?