View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mni
 
Posts: n/a
Default use parameter in getpivotdata

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