Without seeing what your pivot table looks like, it's a bit difficult to
tell you what to do. I've just created my formulas by selecting the
affected cells and the GETPIVOTTABLE function generally appears in my
formulas.

"Mni" wrote in message
...
im using excel 2003 ,i cannot get the required data when using
getpivotdata
at ALL ,i've tried many ways , really need help especially on using a
parameter,eg:

All i need is to get the data about 1SunDAY and DEPOT from the pivot
table



Sum of CountOfEQ_NBR
POW_ID xxouttime Total 1SunDAY DEPOT
DEPOT 1SunDAY 12
1SunNGT 34
3TueDAY 32
3TueNGT 102
4WedDAY 14
4WedNGT 110
5ThuDAY 8
5ThuNGT 17
7SatNGT 2
DEPOT Total 331
Q01 1SunDAY 7
1SunNGT 21
2MonDAY 167
2MonNGT 54
3TueDAY 70
3TueNGT 221
4WedDAY 105
4WedNGT 204
5ThuDAY 12
5ThuNGT 52
6FriDAY 9
6FriNGT 89
7SatDAY 31
7SatNGT 51