Pivot Table Comparisons in Excel 2007

W

whynot0611

Hi!

I work for a translation company and am trying to identify offices that pay
a higher word rate in USD for a specific language.

I am using 2 pivot tables. Pivot table 1 can be filtered by office. Pivot
table 2 is used as the comparison table and left unfiltered (worldwide rates).

I am currently using a basic formula that checks the language in pivot table
1 and copies the average rate from pivot table 2:

IF(B28="Arabic",GETPIVOTDATA("Average Rate",$N$24,"Target Language","Arabic"),
IF(B28="Bulgarian",GETPIVOTDATA("Average Rate",$N$24,"Target
Language","Bulgarian"),
IF(B28="Catalan",GETPIVOTDATA("Average Rate",$N$24,"Target
Language","Catalan"),
etc. I have over 100 languages...

Would it be possible to replace the language names in the formula above by a
variable that would seach for the same language in pivot table 2 and copy the
result beside pivot table 1?
Are there better ways to compare data between pivot tables?

Thanks a lot!
 

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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data 1
Getpivot data dynamic reference 2
Excel 2007 pivot table using analysis services cube as data source 0
Excel 2007 vlookup with Pivot table 0

Top