Calculated field based on two pivot tables by comparing it on Name field

I have a pivot table pointing to one server db table, other pivot table pointing to other server db table. I was not able to join them as i was not having reliable field, agent name was common but both tables has duplicates, so join is slowing operations , soi data is in two different spreadsheets, pivot tables were arranged in one spreadsheet side by side but not related.

in one pivot table i have agents who made appointments per month in a year and grand total per year for that agent

in other pivot, i have agents who handled the total calls per month , 

i need to find average close ratio like number of call handled versus number of appointments made for each agent.(Calculated Column)

agents in one pivot table may be or may not in second pivot, so i need to compare agent field and find this average close ratio per report period.

appointments made:(pivot table)

row label     Jan Feb Mar Apr May June Jul Aug Sep Oct Nov Dec grand total

harry     1    2     5     8    9     

mary            20

kumar          1                                                   9               5  

Calls handled(pivot table)

row label     Jan Feb Mar Apr May June Jul Aug Sep Oct Nov Dec grand total

harry     1    2     5     8    9     

mary            20

kumar          1                                                   9               5  

lucky            4     5                                                        6

two pivot tables are in the same excel spread sheet.

Probably i need a calculated field, but i am not sure how to find the call loss ratio based on fields from two pivot tables

September 12th, 2014 7:40pm

Hi,

Since the issue is more related to the client feature of Excel, I'd like to move it to Excel IT pro forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Best regards,

Luna

Free Windows Admin Tool Kit Click here and download it now
September 13th, 2014 1:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics