Pivot Table Calculated Field

T

tt

I have a pivot table in which the data area includes a 'count' of a text
field. I am trying to create a calculated field which will divide the sum of
a numeric field by this count field but it doesn't seem to be working. The
formula looks as follows:
='sum Field'/COUNT(data field). The result I am getting is simply the sum of
the numeric field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top