Showing Text in a Pivot Table - expanding the amount of options.

Hello all,

I currently have an attendance tracker where a user form inputs the attendance into an excel table.
For speed there is a "Reason" comment box where the reason has been abbreviated into a number code.
The list looks like this.
1 HOL
2 HOL-AM
3 HOL-PM
4 SICK
5 SICK-AM
6 SICK-PM
7 UNPAID
8 B HOL

The issue i am having is when converting these numbers to text in a pivot table I can only seem to convert two.
In the values part of the PivotTable Fields I have changed the number format to custom and added this in

Please Login or Register  to view this content.

however when i try to expand this further for the other 6 in my list it does not work.

I am using a pivot table to use the slicer to filter out the months quickly on the attendance report. I am trying to avoid using vlookups hence why I have decided to approach it this way.

Any suggestions on how to expand this to include all 8 on the list?

Thank you

2 condition is limit for formatting.

If you absolutely want to avoid using VLOOKUP or equivalent.
I'd imagine, that you can use CHOOSE function in source table and use the column as row label.

Assuming data in Column A, with header row.
=CHOOSE(A2,"HOL", "HOL-AM","HOL-PM","SICK","SICK-AM","SICK-PM","UNPAID","B HOL")

I was thinking on something like this too but wanted to know if some one out there knew of a way around this.

I guess this time excel has defeated us.

Thanks for your input