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