Why is my macro changing sum to count?
 

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

Why is my macro changing sum to count?
 

Why not just keep recording while you change the Count to sum?

And include that line in your code, too.

punter wrote:

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

--

Dave Peterson

Why is my macro changing sum to count?
 

That worked. Thanks so much Dave.


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=554243