Is there any way to trace source of a field in a pivot table?

[icytuvi]

Hi there,

I am given a ready-made pivot table having a field with incorrect information so I want to make correction on the source data

(i.e in the below example Banana should be categorized as 'Fruit' instead of 'Vegetable')

However, I cannot find any column in the source data representing the 'Category'.

I have checked to make sure no column is hidden and even checked on the Named Ranges, but found nothing. It is as if the categorization is browsed from out-of-nowhere~~~

Do you have any idea on how I can locate it?

Thanks a lot.

 

[mole999]

you should be able to double click the entry and that should open up the original data on a new sheet

 

[icytuvi]

you should be able to double click the entry and that should open up the original data on a new sheet

Thank you for the input. I tried but it did not work As of now I give up and have no choice than to create another column and pivot again

 

[MARK858]

Can you upload you upload a copy of your workbook to a free file hosting site like www.box.com or www.dropbox.com?
Mark the file for sharing and post the link it provides in the thread (make sure that you amend any sensitive data before uploading).

 

[icytuvi]

Can you upload you upload a copy of your workbook to a free file hosting site like www.box.com or www.dropbox.com?
Mark the file for sharing and post the link it provides in the thread (make sure that you amend any sensitive data before uploading).

Here's the link to the file:

Sample.xlsb

Shared with Dropbox

www.dropbox.com

In the pivot table, field named 'Group2' (column C) having some false information that I want to correct (correction in column B).
Just that I don't know where the data source of 'Group2' is for correction.

I really appreciate if you could take a look at this and help me. Thank you for your time.

 

[MARK858]

What is in...

 

[mole999]

double click on the value in Col E and ite returns the source values

Sample.xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	EXIM	Month	BU	Segment	Product	Group	Unit converter (->Mt)	Q'ty (Mt)	USD/Mt	Biz type	Flexibag	Exporter/ Importer in ENG	Partner's name in short	Product*	Product**	Product(1)
2	Import	Jan	South	Trader	Chilli	Soft oils	0.01638	0.1638	4304.0293	Others	Others	Others	Others	Chilli	Chilli	Chilli
3	Import	Jan	South	Trader	Chilli	Soft oils	0.001092	0.01092	14194.139	Others	Others	Others	Others	Chilli	Chilli	Chilli
4	Import	Jan	South	Trader	Chilli	Soft oils	0.0012	0.024	12916.667	Others	Others	Others	Others	Chilli	Chilli	Chilli
5	Import	Jan	South	Trader	Chilli	Soft oils	0.00226044	0.452088	7131.355	Others	Others	Others	Others	Chilli	Chilli	Chilli
6	Import	Jan	South	Trader	Chilli	Soft oils	0.00226044	0.226044	7131.355	Others	Others	Others	Others	Chilli	Chilli	Chilli
7	Import	Jan	North	Trader	Chilli	Soft oils	0.001638	0.13104	4884.0049	Others	Others	Others	Others	Chilli	Chilli	Chilli
8	Import	Jan	South	Trader	Chilli	Soft oils	0.01638	0.3276	4294.8718	Others	Others	Others	Others	Chilli	Chilli	Chilli
9	Import	Jan	South	Trader	Chilli	Soft oils	0.001092	0.02184	8653.8462	Others	Others	Others	Others	Chilli	Chilli	Chilli
10	Import	Jan	South	Trader	Chilli	Soft oils	0.01638	0.7371	4294.8718	Others	Others	Others	Others	Chilli	Chilli	Chilli
Sheet2

 

[MARK858]

Hi mole999, the OP isn't after a copy of the source values but rather where the source is so they can amend it.
The source is at E:\6. Statistics\Y2019\[YTD Vietnam Oils & Fat statistic 2019.xlsb]raw'!$AM:$BB

 

[mole999]

Hi mole999, the OP isn't after a copy of the source values but rather where the source is so they can amend it.
The source is at E:\6. Statistics\Y2019\[YTD Vietnam Oils & Fat statistic 2019.xlsb]raw'!$AM:$BB

do you mean Row 260, 332, 765 and 766 on raw

 

[MARK858]

No the table is being pulled from a separate workbook.