Posted to microsoft.public.excel.worksheet.functions
|
|
Extract value from Specific Cell
Thanks Roger. Looked at it, I am not able to target the specific Fields in
the Pivot table.
"Roger Govier" wrote:
Hi Dinesh
Take a look at the use of the GetPivotData function. This will solve
your problem.
For help on this go to Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier
"Dinesh" wrote in message
...
Pivot table gives a "Grand Total" of all rows at the end of row. Each
time I
run a Pivot Table, the Grand Total Column is changing from column to
column.
Some time the Grand Total can be find in col "O", "P", "Q" or "R" due
to what
is being fetched. What type of formula can be build where it can look
the
Grand total column and link it to the Grand totals of row by row?
For Example, if a Grand total is on col "P", Row #2, Col "P" to be
link.
If a Grand total is on Col "Q", Row #2, col "Q" to be link.
Thanks in advance for your help.
Dinesh
|