Hi,
I recorded a macro to do amount other things give me a pivot table on
some data. One of the columns in the pivot table should have the total
dollar amount of the invoices within the source data. I record the
macro to give me the sum but when I run it I get the count of then
invoice returned. Here is the line of data that is in the macro:
ActiveSheet.PivotTables("PivotTable4").PivotFields ("AmtDue").Orientation
= _
xlDataField
Does anyone know what I'm doing wrong? I have gotten various debugging
errors before but never had a macro go out of its way to change my
command from sum to count.
Thanks as always,
Eddie.
--
punter
------------------------------------------------------------------------
punter's Profile:
http://www.excelforum.com/member.php...fo&userid=2044
View this thread:
http://www.excelforum.com/showthread...hreadid=554243