Hi,yes i have tried that , but if the pivot is too big and i just want to use
1SunDAY and DEPOT as a guide still it wont

"Debra Dalgleish" wrote:

In the cell where you want the data, type an equal sign, then click on
the cell in the pivot table that contains the 1SunDAY DEPOT data.
The GetPivotData formula should be automatically created.

Mni wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html