Hi everyone,
We’re building a decision-making tool. This tool has tables for Topics, Participants, and Positions – each participant takes a position (‘Go’, ‘No-go’, or ‘I don’t know’) on a topic. Each position type is matched with a numerical value: 1 for ‘Go’, -1 for ‘No-go’, 0 for ‘I don’t know’.
In the pivot table below, we’d like to display the participant’s position in each cell instead of his/her position’s numerical value. Do you guys have an idea of how to get this done?
Thanks!