How do I link to specific cell in "Data" portion of piv table?

  • Thread starter Linking to specific cells in pivot table
  • Start date
L

Linking to specific cells in pivot table

Hi - I was wondering, if there was a way to link another cell in a
spreadsheet to a specific cell in the data portion of a pivot table? I.E. -
in the table below, 'Grand Total' is in the "Data" portion of the pivot table
- can I set up a specific link from another cell to cell C3 so that this
other cell always shows the results of cell C3, regardless of what value is
in cell B3?

A B C
1 Sum of Total Units
2 TOP_LEVEL_ASSY Grand Total
3 Product A 266,459
4 Product B 195,480
5 Product C 84,547
6 Product D 73,859
 

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
Referencing values of a pivot table 1
How to ignore a column of numbers in Grand Total for rows 1
How do I link a cell in a workbook? 1
Peculiar default cell format 1
Demerge cells and copy data 5
sum cells to reach a specific value and return corresponding value 0
help with formula and multiple associated data sets 1

Top