lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have a table which has a column called Salary. in that column, I have number from 10000 to 100000. I create a pivot table from that table. In pivot table, I put Salary field as my Row and then I grouped these number and I got something like the one below. I want to format these number to show something like the following
14K - 25K
26k - 40K
So before grouping, I right click and formatted these number to #,K
but when I group them, I would loos that format. How can I format these numbers after grouping them? Thank you so much.
<colgroup><col></colgroup><tbody>
</tbody>
I have a table which has a column called Salary. in that column, I have number from 10000 to 100000. I create a pivot table from that table. In pivot table, I put Salary field as my Row and then I grouped these number and I got something like the one below. I want to format these number to show something like the following
14K - 25K
26k - 40K
So before grouping, I right click and formatted these number to #,K
but when I group them, I would loos that format. How can I format these numbers after grouping them? Thank you so much.
Row Labels |
14980-24979 |
24980-34979 |
34980-44979 |
44980-54979 |
54980-64979 |
64980-74979 |
74980-84979 |
84980-94979 |
<colgroup><col></colgroup><tbody>
</tbody>