software

Hi Friends,

I have Pivot table something like below mentioned :
Data
CHILD PART NO.FG PART NO.Sum of TOTAL
1010051 ATM0609 11556
1010160 ATM0415 144
PTM0606 2792
PTM0607 3800
1010161 ATM0412 6551
1010162 ATM0415 144
PTM0606 2792
PTM0607 3800

Now, I wish to pull the data quot;FG PART NO.quot; (not the sum of total) as a
result. Is this possible by using quot;getpivotdataquot; function.

Hope u understood my question.
Thanks in advance.

Vikram P. Dhemare

The GetPivotData function can return the data and totals from the pivot
table, but not the field item text.

You can link to a cell that contains a part number, e.g. =B8Vikram Dhemare wrote:
gt; Hi Friends,
gt;
gt; I have Pivot table something like below mentioned :
gt; Data
gt; CHILD PART NO.FG PART NO.Sum of TOTAL
gt; 1010051 ATM0609 11556
gt; 1010160 ATM0415 144
gt; PTM0606 2792
gt; PTM0607 3800
gt; 1010161 ATM0412 6551
gt; 1010162 ATM0415 144
gt; PTM0606 2792
gt; PTM0607 3800
gt;
gt; Now, I wish to pull the data quot;FG PART NO.quot; (not the sum of total) as a
gt; result. Is this possible by using quot;getpivotdataquot; function.
gt;
gt; Hope u understood my question.
gt; Thanks in advance.
gt;
gt; Vikram P. Dhemare--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlThanks Mr. Debra Dalgleish

Is there any option to return the text value? could you give formula with
example
--
Thanks,
Vikram P. Dhemarequot;Vikram Dhemarequot; wrote:

gt; Hi Friends,
gt;
gt; I have Pivot table something like below mentioned :
gt; Data
gt; CHILD PART NO.FG PART NO.Sum of TOTAL
gt; 1010051 ATM0609 11556
gt; 1010160 ATM0415 144
gt; PTM0606 2792
gt; PTM0607 3800
gt; 1010161 ATM0412 6551
gt; 1010162 ATM0415 144
gt; PTM0606 2792
gt; PTM0607 3800
gt;
gt; Now, I wish to pull the data quot;FG PART NO.quot; (not the sum of total) as a
gt; result. Is this possible by using quot;getpivotdataquot; function.
gt;
gt; Hope u understood my question.
gt; Thanks in advance.
gt;
gt; Vikram P. Dhemare

If you provide details on what value you want to return, someone may be
able to help with a formula.

Vikram Dhemare wrote:
gt; Thanks Mr. Debra Dalgleish
gt;
gt; Is there any option to return the text value? could you give formula with
gt; example--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlHere is the pivot table:
ABC
RC1 1010051ATM060911556
RC2 1010160ATM0415144
RC3 PTM06062792
RC4 PTM06073800
RC5 1010161ATM04126551
RC6 1010162ATM0415144
RC7 PTM06062792
RC8PTM06073800
The result would be:

1010162 =INDEX(A1:C8,MATCH(A10,A1:A8,3),row(2),col.(2)) i.e. the returned
field value would bePTM0606
=INDEX(A1:C8,MATCH(A10,A1:A8,3),row(3),col.(2)) i.e. the returned field
value would bePTM0607
I havetried this:
in Cell B10 =INDEX(A1:C8,MATCH(A10,A1:A8,2),2)
in CellB11 =INDEX(A1:C8,MATCH(A10,A1:A8,3),2)
but thevalue is returning ATM0415 i.e the first corresponding row value of
given criteria.
Pl. help me outas I am in desparately need the solution for this.

--
Thanks,
Vikram P. Dhemarequot;Debra Dalgleishquot; wrote:

gt; If you provide details on what value you want to return, someone may be
gt; able to help with a formula.
gt;
gt; Vikram Dhemare wrote:
gt; gt; Thanks Mr. Debra Dalgleish
gt; gt;
gt; gt; Is there any option to return the text value? could you give formula with
gt; gt; example
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;

The following formula would return PTM0606 with 1010162 in cell A10:

=OFFSET(A1,MATCH(A10,A1:A8,1),1)

Vikram Dhemare wrote:
gt; Here is the pivot table:
gt; ABC
gt; RC1 1010051ATM060911556
gt; RC2 1010160ATM0415144
gt; RC3 PTM06062792
gt; RC4 PTM06073800
gt; RC5 1010161ATM04126551
gt; RC6 1010162ATM0415144
gt; RC7 PTM06062792
gt; RC8PTM06073800
gt; The result would be:
gt;
gt; 1010162 =INDEX(A1:C8,MATCH(A10,A1:A8,3),row(2),col.(2)) i.e. the returned
gt; field value would bePTM0606
gt; =INDEX(A1:C8,MATCH(A10,A1:A8,3),row(3),col.(2)) i.e. the returned field
gt; value would bePTM0607
gt; I havetried this:
gt; in Cell B10 =INDEX(A1:C8,MATCH(A10,A1:A8,2),2)
gt; in CellB11 =INDEX(A1:C8,MATCH(A10,A1:A8,3),2)
gt; but thevalue is returning ATM0415 i.e the first corresponding row value of
gt; given criteria.
gt; Pl. help me outas I am in desparately need the solution for this.
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Hi Debra,

This is interesting. Pivottables are so quick and easy to create, and
so useful, but I've not been able to effectively re-use the data
summarised by pivottables into other reports without retyping.

I assume that if the source data changed (say another part number
appear in the following month, then formulae extracting figures from
the pivottable may become invalid.

I understand that any figure in pivottables can be drilled down on to
give all source entries - which is fantastic - but this is the only
report I've been able to effectively reprocess pivottable data into.

Is there any source which explains how to re-use and reprocess
pivottable data? Any tips amp; tricks?

Thanks,--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531163The sample formula in my previous post will pull a field item from the
pivot table. To pull data, you can use the GetPivotData function, as
described in Excel's Help, and he

www.contextures.com/xlPivot06.html

John James wrote:
gt; Hi Debra,
gt;
gt; This is interesting. Pivottables are so quick and easy to create, and
gt; so useful, but I've not been able to effectively re-use the data
gt; summarised by pivottables into other reports without retyping.
gt;
gt; I assume that if the source data changed (say another part number
gt; appear in the following month, then formulae extracting figures from
gt; the pivottable may become invalid.
gt;
gt; I understand that any figure in pivottables can be drilled down on to
gt; give all source entries - which is fantastic - but this is the only
gt; report I've been able to effectively reprocess pivottable data into.
gt;
gt; Is there any source which explains how to re-use and reprocess
gt; pivottable data? Any tips amp; tricks?
gt;
gt; Thanks,
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Thanks Debra. Much clearer now.--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531163