Adding a series of cells in a Pivot Table using GetPivotData function
Is there an efficient way to add a series of cells in a pivot table using GetPivotData function and not the cell reference?
We can definitely do that using "=getpivotdata(......)+getpivotdata(......)+.....", but I would like a more efficient way to do that.
I wouldnt prefer using the cell reference because it would mess up the cells when some more data is added and the contents of pivot changes.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By pcm1969 in forum Excel Charting & Pivots
Last Post: 01-09-2013, 01:28 PM
By shantanuk in forum Excel Charting & Pivots
Last Post: 12-24-2012, 08:20 AM
By Airskip2012 in forum Excel Charting & Pivots
Last Post: 09-08-2012, 06:06 AM
By Hennie in forum Excel Formulas & Functions
Last Post: 06-06-2006, 06:50 PM
By ebergkes in forum Excel General
Last Post: 11-10-2005, 08:30 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1