Background color for hierarchy layout pivot table

Question & Answer
, , ,
1

Hi Team,

I am trying to add the background color to one of the columns in my pivot table with hierarchy layout. However, I noticed that the out layer rows couldn’t be colored when formatting so.

Column 1 Column 2
Technology 30
Google 10
Apple 20

Say for example, I have one industry and several companies under the industry. When coloring the rows, only rows at company level is colored while the industry level doesn’t work. Is there any way I can format the higher level as well?

Thanks,

2

Hi @mmmzzss
did you tried conditional formatting?
BR

1 Like
3

Yea I did. Only the company level gets colored industry level doesn’t.

4

@mmmzzss ,

Can you use the Arena and load a test data to show what is not working : QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

Kind regards,
Koushik

5

Hi @mmmzzss. Since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic.