# Text field as values in pivot tables

**URL:** <https://community.amazonquick.com/t/text-field-as-values-in-pivot-tables/3579>\
**Category:** Q&A\
**Tags:** analysis, quick-sight\
**Created:** [May 12, 2022, 3:23am UTC](https://community.amazonquick.com/t/text-field-as-values-in-pivot-tables/3579 "2022-05-12T03:23:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Wong](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/david_wong/32/15630_2.png) [@David\_Wong](https://community.amazonquick.com/u/David_Wong)\
**Post date:** [May 12, 2022, 3:23am UTC](https://community.amazonquick.com/t/text-field-as-values-in-pivot-tables/3579/1 "2022-05-12T03:23:55Z")

</div>

I have which is currently in this format:

 ![Questions and Answers Flat Table](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/664ca211b711cffe590b18aac8cef88ec380de27.png)

I want to create a visual that shows the data in this format instead:  
 ![Questions and Answers Pivot Table](https://d1wl4jav5dp96l.cloudfront.net/original/2X/c/cd6194d5a7e61252e982bdbb9e08881ce643f983.png)

Is it possible in Quick Sight? I understand that we can’t use text fields as values in a pivot table but I was wondering if there’s any possible workaround.

---

<div class="post-metadata">

**Author:** ![Bchadha](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bchadha](https://community.amazonquick.com/u/Bchadha)\
**Post date:** [May 26, 2022, 5:55am UTC](https://community.amazonquick.com/t/text-field-as-values-in-pivot-tables/3579/2 "2022-05-26T05:55:35Z")

</div>

I don’t think so there is any work around for this. You cannot render text fields as values.