# Adding Custom Text in Value Field - PIVOT Visual **URL:** \ **Category:** Q&A\ **Tags:** pivot-table, formatting, Business-Intelligence-Engineer, quick-sight\ **Created:** [November 15, 2023, 12:13am UTC](https://community.amazonquick.com/t/adding-custom-text-in-value-field-pivot-visual/21231 "2023-11-15T00:13:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hadivann](https://avatars.discourse-cdn.com/v4/letter/h/ed655f/32.png) [@hadivann](https://community.amazonquick.com/u/hadivann)\ **Post date:** [November 15, 2023, 12:13am UTC](https://community.amazonquick.com/t/adding-custom-text-in-value-field-pivot-visual/21231/1 "2023-11-15T00:13:50Z")
Hi Team, I’m using Pivot table & trying to add NA in value fields where it gives zero or blank or null but Quicksight is giving count of records by default and not allowing to show NA in the value field.Can someone suggest on better way to add ‘NA’ text. ---
**Author:** ![bergqdou](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/bergqdou/32/4265_2.png) [@bergqdou](https://community.amazonquick.com/u/bergqdou)\ **Post date:** [November 15, 2023, 12:33am UTC](https://community.amazonquick.com/t/adding-custom-text-in-value-field-pivot-visual/21231/2 "2023-11-15T00:33:42Z")
HI @hadivann Thanks for your question. is there a measure in the visualization? If so, you can click the options for that visual \> format \> more formatting options \>Null values \>custom. ---
**Author:** ![hadivann](https://avatars.discourse-cdn.com/v4/letter/h/ed655f/32.png) [@hadivann](https://community.amazonquick.com/u/hadivann)\ **Post date:** [November 15, 2023, 2:02am UTC](https://community.amazonquick.com/t/adding-custom-text-in-value-field-pivot-visual/21231/3 "2023-11-15T02:02:21Z")
Thank you for your response. Custom null values is working for dimension fields but the value fields are giving the count(Null/NA).