Hide count column from pivot table

Question & Answer
, , ,
1

Hi Team
I want to hide count column from this pivot table. Can someone help me to fix this.

image
image990Ă—460 16.7 KB

2

Hi @irisiri ,

Welcome to the QuickSight Community!!

For this use case, there is no direct way to hide a value field, but I can think of a workaround.

Creating a dummy measure to return 0 and add it to measures with sum/avg aggregation. Then format the cells font colour same as background colour and likewise for header. Make the column width as small possible (~14)

The field would still be available but not visible.

Thanks,
Prantika

1 Like
3

Hi, Pratika.
Thank you for your quick response. I did the same. But I still see the cell colored. And I couldn’t just uncolor one cell because I had the entire dashboard colored in headers.

image
image814Ă—262 8.86 KB

4

Hi @irisiri
maybe you can tell us a bit more about the “why” to see if there is a different way to solve it?
Why do you want to hide the column?
BR

5

Hi @irisiri,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

6

Hi @irisiri,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!