How can I determine which (renamed) values in the pivot table correspond to which values in the source data table?
A simplified example: In the source table, the field 'salesperson' has values 1, 2, 3. In the pivot table, those values were renamed long ago to 'John', 'Sally', 'Dave'.
How can I determine which salesperson name corresponds to which salesperson number? For that matter, how/where does Excel store those assignments?
A simplified example: In the source table, the field 'salesperson' has values 1, 2, 3. In the pivot table, those values were renamed long ago to 'John', 'Sally', 'Dave'.
How can I determine which salesperson name corresponds to which salesperson number? For that matter, how/where does Excel store those assignments?
