Why is my macro changing sum to count?

[punter]

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.

[Dave Peterson]

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

[punter]

That worked. Thanks so much Dave.