Hi Dinesh
I am not able to target the specific Fields in the Pivot table.

I don't understand why not.
You want the Grand Total Column, and you want the result where say
A4="yourvalue"
As you copy down, it will pick up the values where A5="your next Value"
etc.

--
Regards

Roger Govier


"Dinesh" wrote in message
...
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