software

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_IDxxouttimeTotal1SunDAYDEPOT
DEPOT1SunDAY12
1SunNGT34
3TueDAY32
3TueNGT102
4WedDAY14
4WedNGT110
5ThuDAY8
5ThuNGT17
7SatNGT2
DEPOT Total331
Q011SunDAY7
1SunNGT21
2MonDAY167
2MonNGT54
3TueDAY70
3TueNGT221
4WedDAY105
4WedNGT204
5ThuDAY12
5ThuNGT52
6FriDAY9
6FriNGT89
7SatDAY31
7SatNGT51
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.

quot;Mniquot; gt; wrote in message
news
gt; im using excel 2003 ,i cannot get the required data when using
gt; getpivotdata
gt; at ALL ,i've tried many ways , really need help especially on using a
gt; parameter,eg:
gt;
gt; All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt; table
gt;
gt;
gt;
gt; Sum of CountOfEQ_NBR
gt; POW_ID xxouttime Total 1SunDAY DEPOT
gt; DEPOT 1SunDAY 12
gt; 1SunNGT 34
gt; 3TueDAY 32
gt; 3TueNGT 102
gt; 4WedDAY 14
gt; 4WedNGT 110
gt; 5ThuDAY 8
gt; 5ThuNGT 17
gt; 7SatNGT 2
gt; DEPOT Total 331
gt; Q01 1SunDAY 7
gt; 1SunNGT 21
gt; 2MonDAY 167
gt; 2MonNGT 54
gt; 3TueDAY 70
gt; 3TueNGT 221
gt; 4WedDAY 105
gt; 4WedNGT 204
gt; 5ThuDAY 12
gt; 5ThuNGT 52
gt; 6FriDAY 9
gt; 6FriNGT 89
gt; 7SatDAY 31
gt; 7SatNGT 51
gt;
gt;
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:
gt; im using excel 2003 ,i cannot get the required data when using getpivotdata
gt; at ALL ,i've tried many ways , really need help especially on using a
gt; parameter,eg:
gt;
gt; All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt; table
gt;
gt;
gt;
gt; Sum of CountOfEQ_NBR
gt; POW_IDxxouttimeTotal1SunDAYDEPOT
gt; DEPOT1SunDAY12
gt; 1SunNGT34
gt; 3TueDAY32
gt; 3TueNGT102
gt; 4WedDAY14
gt; 4WedNGT110
gt; 5ThuDAY8
gt; 5ThuNGT17
gt; 7SatNGT2
gt; DEPOT Total331
gt; Q011SunDAY7
gt; 1SunNGT21
gt; 2MonDAY167
gt; 2MonNGT54
gt; 3TueDAY70
gt; 3TueNGT221
gt; 4WedDAY105
gt; 4WedNGT204
gt; 5ThuDAY12
gt; 5ThuNGT52
gt; 6FriDAY9
gt; 6FriNGT89
gt; 7SatDAY31
gt; 7SatNGT51
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlLets 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.quot;Mniquot; wrote:

gt; im using excel 2003 ,i cannot get the required data when using getpivotdata
gt; at ALL ,i've tried many ways , really need help especially on using a
gt; parameter,eg:
gt;
gt; All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt; table
gt;
gt;
gt;
gt; Sum of CountOfEQ_NBR
gt; POW_IDxxouttimeTotal1SunDAYDEPOT
gt; DEPOT1SunDAY12
gt; 1SunNGT34
gt; 3TueDAY32
gt; 3TueNGT102
gt; 4WedDAY14
gt; 4WedNGT110
gt; 5ThuDAY8
gt; 5ThuNGT17
gt; 7SatNGT2
gt; DEPOT Total331
gt; Q011SunDAY7
gt; 1SunNGT21
gt; 2MonDAY167
gt; 2MonNGT54
gt; 3TueDAY70
gt; 3TueNGT221
gt; 4WedDAY105
gt; 4WedNGT204
gt; 5ThuDAY12
gt; 5ThuNGT52
gt; 6FriDAY9
gt; 6FriNGT89
gt; 7SatDAY31
gt; 7SatNGT51
gt;
gt;

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

quot;Debra Dalgleishquot; wrote:

gt; In the cell where you want the data, type an equal sign, then click on
gt; the cell in the pivot table that contains the 1SunDAY DEPOT data.
gt; The GetPivotData formula should be automatically created.
gt;
gt; Mni wrote:
gt; gt; im using excel 2003 ,i cannot get the required data when using getpivotdata
gt; gt; at ALL ,i've tried many ways , really need help especially on using a
gt; gt; parameter,eg:
gt; gt;
gt; gt; All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt; gt; table
gt; gt;
gt; gt;
gt; gt;
gt; gt; Sum of CountOfEQ_NBR
gt; gt; POW_IDxxouttimeTotal1SunDAYDEPOT
gt; gt; DEPOT1SunDAY12
gt; gt; 1SunNGT34
gt; gt; 3TueDAY32
gt; gt; 3TueNGT102
gt; gt; 4WedDAY14
gt; gt; 4WedNGT110
gt; gt; 5ThuDAY8
gt; gt; 5ThuNGT17
gt; gt; 7SatNGT2
gt; gt; DEPOT Total331
gt; gt; Q011SunDAY7
gt; gt; 1SunNGT21
gt; gt; 2MonDAY167
gt; gt; 2MonNGT54
gt; gt; 3TueDAY70
gt; gt; 3TueNGT221
gt; gt; 4WedDAY105
gt; gt; 4WedNGT204
gt; gt; 5ThuDAY12
gt; gt; 5ThuNGT52
gt; gt; 6FriDAY9
gt; gt; 6FriNGT89
gt; gt; 7SatDAY31
gt; gt; 7SatNGT51
gt; gt;
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

Hi there, Big thanks ,its work!,but how if i dont need to type in the quot;DEPOT
and 1SunDAYquot; but just point it to the parameter cell?any formulas?

quot;MarkMquot; wrote:

gt; Lets see if I can help, I am new to the getpivotdata function as well, but
gt; had similar issues at first. If I understand correctly as what you are
gt; trying to get, you want to get the depot 1Sunday total, which is 12.
gt;
gt; Assuming the example you have given the entire pivot table and the cell with
gt; the Sum of CountOfEQ_NBR is in A5. If you enter the function as follows I
gt; think it should give what you are looking for.
gt;
gt; =GETPIVOTDATA(A5,” DEPOT 1SunDAY”) should return 12.
gt;
gt; Hope this works for you.
gt;
gt;
gt; quot;Mniquot; wrote:
gt;
gt; gt; im using excel 2003 ,i cannot get the required data when using getpivotdata
gt; gt; at ALL ,i've tried many ways , really need help especially on using a
gt; gt; parameter,eg:
gt; gt;
gt; gt; All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt; gt; table
gt; gt;
gt; gt;
gt; gt;
gt; gt; Sum of CountOfEQ_NBR
gt; gt; POW_IDxxouttimeTotal1SunDAYDEPOT
gt; gt; DEPOT1SunDAY12
gt; gt; 1SunNGT34
gt; gt; 3TueDAY32
gt; gt; 3TueNGT102
gt; gt; 4WedDAY14
gt; gt; 4WedNGT110
gt; gt; 5ThuDAY8
gt; gt; 5ThuNGT17
gt; gt; 7SatNGT2
gt; gt; DEPOT Total331
gt; gt; Q011SunDAY7
gt; gt; 1SunNGT21
gt; gt; 2MonDAY167
gt; gt; 2MonNGT54
gt; gt; 3TueDAY70
gt; gt; 3TueNGT221
gt; gt; 4WedDAY105
gt; gt; 4WedNGT204
gt; gt; 5ThuDAY12
gt; gt; 5ThuNGT52
gt; gt; 6FriDAY9
gt; gt; 6FriNGT89
gt; gt; 7SatDAY31
gt; gt; 7SatNGT51
gt; gt;
gt; gt;

You can type the field names and items in cells, and refer to those
cells in the formula, e.g.:

=GETPIVOTDATA(quot;CountOfEQ_NBRquot;,$A$6,G5,G6,H5,H6)

where G5=POW_ID
G6=DEPOT
H5=xxouttime
H6=1SunDAYMni wrote:
gt; Hi there, Big thanks ,its work!,but how if i dont need to type in the quot;DEPOT
gt; and 1SunDAYquot; but just point it to the parameter cell?any formulas?
gt;
gt; quot;MarkMquot; wrote:
gt;
gt;
gt;gt;Lets see if I can help, I am new to the getpivotdata function as well, but
gt;gt;had similar issues at first. If I understand correctly as what you are
gt;gt;trying to get, you want to get the depot 1Sunday total, which is 12.
gt;gt;
gt;gt;Assuming the example you have given the entire pivot table and the cell with
gt;gt;the Sum of CountOfEQ_NBR is in A5. If you enter the function as follows I
gt;gt;think it should give what you are looking for.
gt;gt;
gt;gt;=GETPIVOTDATA(A5,” DEPOT 1SunDAY”) should return 12.
gt;gt;
gt;gt;Hope this works for you.
gt;gt;
gt;gt;
gt;gt;quot;Mniquot; wrote:
gt;gt;
gt;gt;
gt;gt;gt;im using excel 2003 ,i cannot get the required data when using getpivotdata
gt;gt;gt;at ALL ,i've tried many ways , really need help especially on using a
gt;gt;gt;parameter,eg:
gt;gt;gt;
gt;gt;gt;All i need is to get the data about 1SunDAY and DEPOT from the pivot
gt;gt;gt;table
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;Sum of CountOfEQ_NBR
gt;gt;gt;POW_IDxxouttimeTotal1SunDAYDEPOT
gt;gt;gt;DEPOT1SunDAY12
gt;gt;gt;1SunNGT34
gt;gt;gt;3TueDAY32
gt;gt;gt;3TueNGT102
gt;gt;gt;4WedDAY14
gt;gt;gt;4WedNGT110
gt;gt;gt;5ThuDAY8
gt;gt;gt;5ThuNGT17
gt;gt;gt;7SatNGT2
gt;gt;gt;DEPOT Total331
gt;gt;gt;Q011SunDAY7
gt;gt;gt;1SunNGT21
gt;gt;gt;2MonDAY167
gt;gt;gt;2MonNGT54
gt;gt;gt;3TueDAY70
gt;gt;gt;3TueNGT221
gt;gt;gt;4WedDAY105
gt;gt;gt;4WedNGT204
gt;gt;gt;5ThuDAY12
gt;gt;gt;5ThuNGT52
gt;gt;gt;6FriDAY9
gt;gt;gt;6FriNGT89
gt;gt;gt;7SatDAY31
gt;gt;gt;7SatNGT51
gt;gt;gt;
gt;gt;gt;
gt;gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html