Display alternative text in pivot table

[DebB]

I am using a pivot table set up by someone else about 5 years ago. One of the fields is 'Staff Type' and data validation forces the user to select from "A" "G" or "V". However, on the pivot table, the Staff Type Field displays "Academic" "General" or "Visitor" in the sub headings. I can easily replace the data to get whichever I ultimately want displayed, but I want to know why this is happening? I can't find any field settings that tell the pivot table to display alternative text to what is in the table. Any clues?

 

[Marcelo Branco]

Hi,

Maybe the PVT was created using VBA and at the end of the code there is something like (assuming the field Staff Type is in column D, for example)

With Range("D:D")
    .Replace "A", "Academic"
    .Replace "G", "General"
    .Replace "V", "Visitor"
End With

Check

M.

 

[DebB]

Thanks Marcelo, the woman who set it up never mentioned VBA *ever* but it makes sense There has to be something somewhere telling it to change the data.

 

[Marcelo Branco]

The only plausible explanation for me is VBA...

M.