How to stop pivot table from counting?

[Marist07]

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]

 

[PolarBear]

Did you try going to the "Field Settings", and setting it for "Sum" as opposed to "Count"?

 

[Marist07]

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]

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]

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]

You don't put it anywhere; Excel normally handles that for you. It might help if you post your table.