# Pivot Table with Text Values

**URL:** <https://air.tableforums.com/t/pivot-table-with-text-values/1406>\
**Category:** Airtable Questions\
**Created:** [January 9, 2025, 11:19am UTC](https://air.tableforums.com/t/pivot-table-with-text-values/1406 "2025-01-09T11:19:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JBJ](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/jbj/32/1063_2.png) [@JBJ](https://air.tableforums.com/u/JBJ)\
**Post date:** [January 9, 2025, 11:19am UTC](https://air.tableforums.com/t/pivot-table-with-text-values/1406/1 "2025-01-09T11:19:03Z")

</div>

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!

 ![CleanShot 2025-01-09 at 12.01.42](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/2X/8/8c385a179ad831710be3092bfcc07748084c0e7a.png)