Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to Use pivot tables in a calculation
I have some data in a pivot table which I want to use in a calculation but
when I try to key off a cell in the table the new cell is a calculation ....GetPivotTable....... and it is impossible to drag this cell down to other cells that correspond to other cells in the pivot table. Am I explaining myself?? Or: How do I refer to the contents of a cell in a pivot table? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to Use pivot tables in a calculation
Manually type a simple link formula
which points to the top left cell within the pivot, eg: =B5 Then you can copy it across/down as required Debra explains how to switch the feature off he http://www.contextures.com/xlPivot06.html Excel -- Pivot Tables -- GetPivotData -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Mervyn Thomas" wrote: I have some data in a pivot table which I want to use in a calculation but when I try to key off a cell in the table the new cell is a calculation ....GetPivotTable....... and it is impossible to drag this cell down to other cells that correspond to other cells in the pivot table. Am I explaining myself?? Or: How do I refer to the contents of a cell in a pivot table? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to Use pivot tables in a calculation
Hi Mervyn
You can replace the direct row names in the GetPivotData formula, with the cell reference that contains the name. Then, as you copy down, the formula adjusts to suit the row name. The same applies to columns. Take a look at the help on this function at http://www.contextures.com/xlPivot06.html It just takes a little while to get used to tweaking the GetPivotData function, but it is far better than using direct cell references, as there is no guarantee that the references will remain th same after additions to the source data and a Refresh. -- Regards Roger Govier "Mervyn Thomas" wrote in message ... I have some data in a pivot table which I want to use in a calculation but when I try to key off a cell in the table the new cell is a calculation ...GetPivotTable....... and it is impossible to drag this cell down to other cells that correspond to other cells in the pivot table. Am I explaining myself?? Or: How do I refer to the contents of a cell in a pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation: Automatic except tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Appending columns or calculation to pivot tables | Excel Discussion (Misc queries) | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |