Referencing values of a pivot table

G

Guest

Hi - I was wondering how I could reference a specific cell of a pivot table?
I.E. in the following pivot table, I want to link the results of cell C3 to
another cell in the spreadsheet -- basically, I always want this other cell
to pull from cell C3, regardless of what TOP_LEVEL_ASSY cell C3 is showing
data for.

A B C
1 Sum of Total DF Units
2 TOP_LEVEL_ASSY Grand Total
3 CISCO1721 266,459
4 CISCO837-K9 195,480
5 CISCO831-K9 84,547
6 CISCO836-K9 73,859
 
F

Frank Kabel

Hi
simply enter
=C3
in your cell?

--
Regards
Frank Kabel
Frankfurt, Germany

"Linking to specific cells in pivot table" <Linking to specific cells
in pivot (e-mail address removed)> schrieb im Newsbeitrag
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to specific cell in Piv Table 1
Average of Subtotals in Pivot Table 0
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table - copy specified Grand Totals 1
Summing Problem In A Pivot Table 1
Pivot Tables 1
Pivot Table 1
Pivot Table Summary Error? 6

Top