What formula do you get if you type an equal sign, and click on the cell
with the Oct-06 sum, for Loc 04?

The book has about 12 pages on the GETPIVOTDATA function.

Lindy1 wrote:
Yeah, I had tried the "1" and 1 deal. No change. I got it to work by dropping
one of the fields as follows...
=GETPIVOTDATA("Oct-06",MMA_TAC,"RC","1","Loc","04") I went back to the
spreadsheet and renamed the "Include Field" column to "Field", refreshed the
PT, added "Flag","Y", back into the GETPIVOTDATA formula and it comes back
with an error message. I drop the "Flag","Y", out and it works.
This is how the PT looks...
Loc
RC Flag Data 04 Grand Total
1 Y Count of Tool Code 539.0 539.0
Sum of Oct-06 0.0 0.0
Sum of Nov-06 142.0 142.0
Sum of Dec-06 387.3 387.3

Does your Pivot Tables book have a chapter on the GETPIVOTDATA function?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html