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 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

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