How to stop pivot table from counting?

Marist07

New Member
Joined
Jul 6, 2005
Messages
43
How can I stop my pivot table from counting? I just want to be able to put the actual values in there, not to count the number of times there is a value for the certain record. Thanks!

Here's an example:

I order 11 things at 14.95.

I need to put the number ordered in the pivot table and multiply that number by the price (14.95). The problem is, that when I put the numberordered in the pivot table, instead of giving me the 11, it counts that value as 1. How can i have it show the actual value, not just as one counted field?

thanks for the help!

-dave

[Subject line edited by admin to reflect the subject of the post]
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

PolarBear

Board Regular
Joined
Sep 26, 2005
Messages
215
Did you try going to the "Field Settings", and setting it for "Sum" as opposed to "Count"?
 

Marist07

New Member
Joined
Jul 6, 2005
Messages
43
I did. I think I got it to work, but how to I get to multiply two columns in the pivot table in the Total Column? I need to multiply in the data fields (the price) by the quantity in the Row area. is there a way that can be done?


thanks for the reply! hope to hear back!
 

PolarBear

Board Regular
Joined
Sep 26, 2005
Messages
215
Click somewhere on your pivot table, then go to the pivot table wizard, and select "Formulas", then click on "Calculated Field". Give it a name live "Revenue", and set it equal to Quantity * Price (or whatever your field names are). This will add a field to your pivot table that is the product of the other two fields.
 

Marist07

New Member
Joined
Jul 6, 2005
Messages
43
This is fine, but it does not work. I do not know where to put the field because when I put it in the data area, all the numbers come out as Zero because it is trying to sum it. That is the problem.

WHy does excel keep automatically summing the numbers... ?

If it did not do this, it probably would work.... i did the field settings, but it still did not do anything...

help.. eek! thanks for the replies
 

PolarBear

Board Regular
Joined
Sep 26, 2005
Messages
215
You don't put it anywhere; Excel normally handles that for you. It might help if you post your table.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,598
Messages
5,541,163
Members
410,543
Latest member
ExcelGlenn
Top