Divide pivot table data by an arbitrary column in another table

Posted by rsavu on Super User See other posts from Super User or by rsavu
Published on 2010-07-13T14:45:09Z Indexed on 2011/01/06 9:56 UTC
Read the original article Hit count: 336

Filed under:
|
|

Hello all,

I have this data from a pivot table:

Countries   P1  P2  Total
Country 1   10      69
Country 2   36  2   92
Country 3   21  24  100
Country 4   22      77
Country 5   13      79
Country 6   12  1   48
Country 7   14      29
Country 8   22  1   46
Country 9   4   1   31
Country 10  16  7   120
Country 11  25  2   114
Country 12  8   11  68
Country 13  5       27
Country 14  11  3   23
Country 15  6       19
Country 16  33      79

Where:

  • 1st column is the country name
  • 2nd and 3rd column are the tickets introduced in the system
  • 4th column is the total (disregard the data - total is not accurate)

Additionally, I have another table that looks like this:

Country P1  P2
Country 1   2   3
Country 2   2   2
Country 3   0   2
Country 4   0   3
Country 5   1   1
Country 6   2   2
Country 7   1   2
Country 8   3   3
Country 9   1   4
Country 10  2   1
Country 11  4   2
Country 12  2   1
Country 13  3   2
Country 14  3   3
Country 15  1   2
Country 16  2   2

Where the data represents the number of users of the application in each country.

I want to be able to show the number of tickets submitted divided by the number of users in each country. Any ideeas how to do that?

Thank you very much,

Razvan

© Super User or respective owner

Related posts about excel

Related posts about excel-2003