Seba Robles
Board Regular
- Joined
- May 16, 2018
- Messages
- 71
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello,
I have a data set in which I added a custom cell format for one of the columns (the column is named Level/Rank);
But when I add a pivot table and place the Level/Rank column under Row Labels, the pivot wont show it with the custom format from the data source.
Instead of 12, 10, 9, etc. it should say LVL 12, LVL 10, LVL 9 and so on.
Any idea if this can be done and how?
Thanks in advance!!
I have a data set in which I added a custom cell format for one of the columns (the column is named Level/Rank);
But when I add a pivot table and place the Level/Rank column under Row Labels, the pivot wont show it with the custom format from the data source.
Instead of 12, 10, 9, etc. it should say LVL 12, LVL 10, LVL 9 and so on.
Any idea if this can be done and how?
Thanks in advance!!