Hi,

I am wanting to remove the function in the name of a pivot table field.

If i go to rename and remove 'Sum of' it rejects based on the pivot report
already having that variable.

Any clues?

By the way when you use an auto format, this function is appllied - ie it
gives you the title Volume rather than Sum of Volume.

Cheers,

M

Add an extra space character at the end???

"Sum of Amount"
becomes
"Amount "
(without the quotes)

Marlyn wrote:

Hi,

I am wanting to remove the function in the name of a pivot table field.

If i go to rename and remove 'Sum of' it rejects based on the pivot report
already having that variable.

Any clues?

By the way when you use an auto format, this function is appllied - ie it
gives you the title Volume rather than Sum of Volume.

Cheers,

M



--

Dave Peterson

I encountered a similar problem. I found that in a pivot table you can't
give a field the same name as one of the columns from your original data
set. Change the name slightly and you should be able to remove the "Sum
of". The problem that I'm having, however, is that even if I change the
name, the sum function remains - summing my data where I don't want it
to. If you can help me on that, let me know.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545112

I encountered a similar problem. I found that in a pivot table you can't
give a field the same name as one of the columns from your original data
set. Change the name slightly and you should be able to remove the "Sum
of". The problem that I'm having, however, is that even if I change the
name, the sum function remains - summing my data where I don't want it
to. If you can help me on that, let me know.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545112