pivot table!

hi all!

in my pivot table while i am trying to add field names in the data area i am getting only the "count" and not the "sum". but my target is only the "sum"?of course..the filed is formatted as number!
what's wrong with me?

help pl?

-via135

If excel puts Count, then that means you have at least one entry in that field
that is text or empty.

When you're building the pivottable, just double click on that "Count of" button
and select Sum.

But if you think all your entries are real numbers (no text, no blank cells),
then you have a problem. Formatting the cell as a number isn't enough to make
the existing value a number.

I'd select an empty cell.
edit|copy
select all the cells in that field/column
edit|paste special|Add.

This should convert the text numbers to number numbers.



via135 wrote:
>
> hi all!
>
> in my pivot table while i am trying to add field names in the data area
> i am getting only the "count" and not the "sum". but my target is only
> the "sum"?of course..the filed is formatted as number!
> what's wrong with me?
>
> help pl?
>
> -via135
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=508666

--

Dave Peterson

thks Dave!

you have exactly pinpointed my problem! after double clicking the "countof" and selecting the "sum" option i am able to get the sum of items!

but one more hurdle..i am having two fields called "Dr" & "Cr"! while i am trying both the fileds in the data field the pivot table gives me only the count! but while trying with one field i can select the option (as per your tip) sum,count,max...etc?

help me pl?

-via135

You should be able to drag the DR field to the data area, then double click and
change it.

Then drag the CR field to that same data area and do the same thing.



via135 wrote:
>
> thks Dave!
>
> you have exactly pinpointed my problem! after double clicking the
> "countof" and selecting the "sum" option i am able to get the sum of
> items!
>
> but one more hurdle..i am having two fields called "Dr" & "Cr"! while i
> am trying both the fileds in the data field the pivot table gives me
> only the count! but while trying with one field i can select the option
> (as per your tip) sum,count,max...etc?
>
> help me pl?
>
> -via135
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=508666

--

Dave Peterson

yes..i got it!

thks Dave!

-via135

Originally Posted by Dave Peterson

You should be able to drag the DR field to the data area, then double click and
change it.

Then drag the CR field to that same data area and do the same thing.



via135 wrote:
>
> thks Dave!
>
> you have exactly pinpointed my problem! after double clicking the
> "countof" and selecting the "sum" option i am able to get the sum of
> items!
>
> but one more hurdle..i am having two fields called "Dr" & "Cr"! while i
> am trying both the fileds in the data field the pivot table gives me
> only the count! but while trying with one field i can select the option
> (as per your tip) sum,count,max...etc?
>
> help me pl?
>
> -via135
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=508666

--

Dave Peterson