GETPIVOTDATA on Excel 2000

  • Thread starter Thread starter Louja
  • Start date Start date
L

Louja

Hi,

I have seen that you can use GETPIVOTDATA with more than one field on
Excel 2003 and 2007. But is there any way of doing this with Excel
2000.

I am currently using SUMPRODUCT to do a vlookup which has more than
one variable. Is there another solution as this takes forever when
the spreadsheet needs to recalculate.
 
Yes, you can use multiple fields in an Excel 2000 GETPIVOTDATA formula.
For example, to see records for the Central region, for Truck sales, by
salesperson Wilson:

=GETPIVOTDATA($A$4,"Central Trucks Wilson")
 
Back
Top