# How to remove count column from a pivot table chart

**URL:** <https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [June 10, 2022, 10:36am UTC](https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128 "2022-06-10T10:36:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 10, 2022, 10:36am UTC](https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128/1 "2022-06-10T10:36:02Z")

</div>

Dear Community,  
I want a view of a pivot table but I don’t want to see the count column in my view. So is there any way how do I remove the count column?  
PFA the view of my analysis.

 ![Count_Column](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/642f3926122091355af5e6bdf3b0bdfe812168ff.png)

---

<div class="post-metadata">

**Author:** ![thomask](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/thomask/32/3124_2.png) [@thomask](https://community.amazonquick.com/u/thomask)\
**Post date:** [June 10, 2022, 10:55pm UTC](https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128/2 "2022-06-10T22:55:59Z")

</div>

I think its not possible to remove the column.  
But I think you could use conditional formatting to make the font color the same as the background color, so you dont see the values. Or use a column, that has no values as a placeholder.

You can insert a space as the metric name, so it does not appear in the header.

---

<div class="post-metadata">

**Author:** ![kaushik1710](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@kaushik1710](https://community.amazonquick.com/u/kaushik1710)\
**Post date:** [February 8, 2023, 4:58pm UTC](https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128/3 "2023-02-08T16:58:04Z")

</div>

Hello i’m having the same issue and i’m not able to use conditional formatting for the field can you please help me.

---

<div class="post-metadata">

**Author:** ![royyung](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/royyung/32/3302_2.png) [@royyung](https://community.amazonquick.com/u/royyung)\
**Post date:** [September 18, 2024, 3:10pm UTC](https://community.amazonquick.com/t/how-to-remove-count-column-from-a-pivot-table-chart/4128/4 "2024-09-18T15:10:25Z")

</div>

you need to add a column in the pivot table, in this case, I have chosen “Sales”  
Then choose “conditional formatting”.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/7/a/7a185bb1b03347aa2de0434780a248caceca21f5.png)

And define the text and background color to be the same such as white or grey  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/b/0bb718af4a037c69d45a0b02df0f6a704085d04d.png)

Rename the sales column with space  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/5/d/5dd0610b0be0370177a941af6e72818285ff882c.png)