|
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 |
use parameter in getpivotdata
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 |
use parameter in getpivotdata
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 |
use parameter in getpivotdata
Lets see if I can help, I am new to the getpivotdata function as well, but
had similar issues at first. If I understand correctly as what you are trying to get, you want to get the depot 1Sunday total, which is 12. Assuming the example you have given the entire pivot table and the cell with the Sum of CountOfEQ_NBR is in A5. If you enter the function as follows I think it should give what you are looking for. =GETPIVOTDATA(A5,€¯ DEPOT 1SunDAY€¯) should return 12. Hope this works for you. "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 |
use parameter in getpivotdata
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 |
use parameter in getpivotdata
Hi there, Big thanks ,its work!,but how if i dont need to type in the "DEPOT
and 1SunDAY" but just point it to the parameter cell?any formulas? "MarkM" wrote: Lets see if I can help, I am new to the getpivotdata function as well, but had similar issues at first. If I understand correctly as what you are trying to get, you want to get the depot 1Sunday total, which is 12. Assuming the example you have given the entire pivot table and the cell with the Sum of CountOfEQ_NBR is in A5. If you enter the function as follows I think it should give what you are looking for. =GETPIVOTDATA(A5,€¯ DEPOT 1SunDAY€¯) should return 12. Hope this works for you. "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 |
use parameter in getpivotdata
You can type the field names and items in cells, and refer to those
cells in the formula, e.g.: =GETPIVOTDATA("CountOfEQ_NBR",$A$6,G5,G6,H5,H6) where G5=POW_ID G6=DEPOT H5=xxouttime H6=1SunDAY Mni wrote: Hi there, Big thanks ,its work!,but how if i dont need to type in the "DEPOT and 1SunDAY" but just point it to the parameter cell?any formulas? "MarkM" wrote: Lets see if I can help, I am new to the getpivotdata function as well, but had similar issues at first. If I understand correctly as what you are trying to get, you want to get the depot 1Sunday total, which is 12. Assuming the example you have given the entire pivot table and the cell with the Sum of CountOfEQ_NBR is in A5. If you enter the function as follows I think it should give what you are looking for. =GETPIVOTDATA(A5,€¯ DEPOT 1SunDAY€¯) should return 12. Hope this works for you. "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 |
| All times are GMT +1. The time now is 10:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com