Pivot table-group custom name

[Sophia Tsoleridou]

Hello everyone.

I have this problem when working with a pivot table: I group items and then in the Value field settings I change the custom name of the field.

The new name apperars in the PivotTable Fields panel but it doesn't appear in the body of the pivot table.

I tried som many times watched tutorials, but nothing...

Does someone have any idea?

Thank you!

Sophia

[#2]

Hi Sophia,

Sorry, i didn't catch what exactly doesn't work. Let do on example

You group some field

You may change group name in formula bar

After that you may change from Value field setting the name of Value

it appears both in panel and in column name.

Is that like this?

[#3 · Accepted solution]

Thank you so, so, so , so much!!!

I haven't thought using this....

You solved a major problem for me!!!

THANK YOU!!!

[#4]

That's really "Best response" :)