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