Changing the label of a Sum field in Values Field (DataField)

**bezwlosy** · 09-18-2014, 05:46 AM

Hello, I'm working on Excel 2007.

I would like to ask for help. I'm posting the picture so it will be visible, what I will try to explain. pivottable.png
The picture is in Polish, but I assume it is the same for all languages?

I have a Pivot Table with few fields. I would like to add Value Field to sum up some data. The problem is that if there is only one field that is summed up, than the label is "Sum" (Suma in Polish).
When there are more fields added, it is how I would like the field to be labeled if there is only one. It is labeled then "Sum of....". I want the same even if only one field is added.

I cannot change it manually by clicking on Sum and then the settings, because nothing happens.

If there is only one summing Value Field, the label I would like to have goes up and to the left of the table.

"Wartości" in the upper side of the table with more fields means "values".

Does it depend on the version of Excel? I have only 2007 to test on.

My goal is to change it with VBA, but how it is possible?

Thank you everyone.

pivottable.png
I

**romperstomper** · 09-18-2014, 05:52 AM

I can't recall 2007, but in 2010 you get your layout when you have the Classic pivot table layout applied. If you turn that off in the pivot table options, you should see the actual field header (assuming it's not a .xls format workbook).

**Richard Buttrey** · 09-18-2014, 05:56 AM

Hi,

I don't understand exactly what you want. Please upload the actual workbook - pictures are no help, none of us are inclined to recreate your workbook just to test something.

Manually add or make a note of what you want to see. It might be that you can just use the 'Custom Name' option but until you explain a little more I can't say.

**bezwlosy** · 09-18-2014, 05:58 AM

Originally Posted by romperstomper

I can't recall 2007, but in 2010 you get your layout when you have the Classic pivot table layout applied. If you turn that off in the pivot table options, you should see the actual field header (assuming it's not a .xls format workbook).

Yes it is also working in 2007. Thank you.
Unfortunately I need to work on Classic layout. I wonder if it is also possible here.

Thanks.

@Richard Buttrey
What I want to see is the label "Sum of Workers" [Polish: "Suma z Workers"] (instead of "Sum" [Polish: "Suma") of a Value field in the case where there is only one Value field added (bottom example in the picture)
It is stated above the second pivot table, but I have to have it exactly in the field where "Suma" currently is.

**romperstomper** · 09-18-2014, 06:33 AM

I'm afraid it's not possible to change the Classic layout behaviour.

**Richard Buttrey** · 09-18-2014, 06:57 AM

[QUOTE=bezwlosy;3838104
@Richard Buttrey
What I want to see is ...[/QUOTE]

Please upload the workbook as requested.

Changing the label of a Sum field in Values Field (DataField)

LinkBack

Thread Tools

Rate This Thread

Display

Changing the label of a Sum field in Values Field (DataField)

Re: Changing the label of a Sum field in Values Field (DataField)

Re: Changing the label of a Sum field in Values Field (DataField)

Re: Changing the label of a Sum field in Values Field (DataField)

Re: Changing the label of a Sum field in Values Field (DataField)

Re: Changing the label of a Sum field in Values Field (DataField)

Thread Information

Users Browsing this Thread

Similar Threads

import values from an access accdb database to use as lookup field in excel field

Changing a numerical field to a date field

Can I pull field as datafield or as a output from a pivot table re

Changing a text field to a date field

How to keep leading zero without changing field to text field?

Bookmarks

Bookmarks

Posting Permissions