I'm having trouble with the getpivotdata function.
Everything works fine if the only data I have in my table is the sum, or the count of a field. When I try to include both the sum and the count of the field in the data area of the pivot table, my getpivotdata function doesn't work.
Can this be done, and if so, what type of code must i put in my formula to indicate if I want the sum or the count returned using the GETPIVOTDATA function?
Everything works fine if the only data I have in my table is the sum, or the count of a field. When I try to include both the sum and the count of the field in the data area of the pivot table, my getpivotdata function doesn't work.
Can this be done, and if so, what type of code must i put in my formula to indicate if I want the sum or the count returned using the GETPIVOTDATA function?