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