can you add two cells in a getpivottable function?
D Debra Dalgleish Sep 26, 2006 #2 You can use two GetPivotData functions in one formula: =GETPIVOTDATA("Units",$B$5,"Region","East") + GETPIVOTDATA("Units",$B$5,"Region","West")
You can use two GetPivotData functions in one formula: =GETPIVOTDATA("Units",$B$5,"Region","East") + GETPIVOTDATA("Units",$B$5,"Region","West")
