XP Pivottable referances

T

Tom OLsen

All,


When you add two cells that belong to a pivottable you
get syntax like this "=GETPIVOTDATA("Cost
Out",$A$3,"Business_Unit","Corporate IT
Spending","PRFINISH",DATE(2003,1,5))+GETPIVOTDATA("Cost
Out",$A$3,"Business_Unit","EIA-ISS-Support","PRFINISH",DATE
(2003,1,12))"

How do I add cells in a pivot table without all of
these references? I can not make a calculation now because
I've exceed 256 characters.

All help appreciated!!

Tom
 
D

Debra Dalgleish

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.
 
Top