Pivot Table Calculating Field Help

K

KR

I have figured out how to create a Pivot Table but I cannot fiure out how to
calculate anything. Here is what I have:

Fields:
Name (the full name of the physician, mind you one physician may have
implanted 60 of ONE specific device and another physician maybe implanted 60
of EACH device)
Study (the type of device implanted, there are about 10 different types of
devices)
Imp Country (all the different countries the devices have been implanted in)
Site (the name of the hospital the device was implanted at)

I need to be able to either filter by the physician to see how many of each
device this phsyican has implanted....or
how many of a specific device has been implanted in a specific country....or
how many devices have been implanted at a specific institution....or
ect....
Basically information that can be provided by these fields I will need...can
someone help me figure out how to calculate all this information now that I
have it in the Pivot Table? RIght now I have all 4 fields in the drop filter
fields here field if that makes sense?
THank you so much for anyone who can help me!!!
 
D

Daryl S

KR -

If your records are one per implanted device, then add a Count(Study) to the
data area. If instead you have a field that includes the number of devices
implanted for the Name, Imp Country, and Site, then you need to add a
Sum(countfield) to the data area.
 

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