Adding a calculated field to a pivot table
Unfortunately, calculated fields caculate off the original table, not the
pivot table.
An alternate option is to calculate outside the table. So, assuming you have
your headers in A3 through C3, and each subject takes up to rows, Try going
to D5 and typing C5/C4. Highlight D4 to D5, copy, paste down to the bottom.
"DanL" wrote:
I have a pivot table that includes these fields:
1. A count of "Traffic types" (which are text)
2. A count of "Sales Dollars" (which is in currency)
I want to add a calculated field that will take #2 above and divide it by #1.
When I create such a field (= 'Sale '/ 'Traffic Type') I get a divide by
zero error, even though fields are populated. I am trying to get to a
"closing %". Can anyone advise me as to where I am making my error?
Thanks!
Dan
|