Forum Discussion

Sophia Tsoleridou's avatar
Sophia Tsoleridou
Copper Contributor
Jun 13, 2017
Solved

Pivot table-group custom name

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

 

excel
  • Sophia Tsoleridou's avatar
    Sophia Tsoleridou
    Jun 13, 2017

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

     

    I haven't thought using this....

    You solved a major problem for me!!!

     

    THANK YOU!!!

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 13, 2017

    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?

     

     

     

     

     

     

    • Sophia Tsoleridou's avatar
      Sophia Tsoleridou
      Copper Contributor
      Jun 13, 2017

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

       

      I haven't thought using this....

      You solved a major problem for me!!!

       

      THANK YOU!!!

Resources