Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Best Practices" Use of GetPivotData Function | Excel Worksheet Functions | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
Data_field parameter in getpivotdtata as a cell reference. | Excel Discussion (Misc queries) | |||
Copy GetPivotData Outside Report | Excel Worksheet Functions | |||
Wildcard parameter in excel | Excel Discussion (Misc queries) |