HI Team , I have a pivot table as shown below. I want to color the column based on the “name” and "change " for individual condition. For example , for weight if change>0 then I want it to red, if (name = “alcohol per week” and change >0 then to Red, if(name="fruits per week " and change >0 then…

Hello Deepika, You could use conditional formatting - For more info see - Conditional formatting on visual types in QuickSight - Amazon QuickSight Hope this helps. Cheers, Deep

Thank you @Deep , I have tried that but couldn’t get the desired result . We need a condition with the combination row and column values to get my required result.

Hello Deepika, I am not sure how helpful it is but you could refer this couple os post to get some insight/ideas [image] Conditional formatting per row - highest value Question & Answer Is there a way to use conditional formatting to show me which value of the column is t…

Actually in this case I am getting an error of mismatched aggregation while creating the calculated field. My calculation is as below ifelse({name}=“weight” and {change} >=0 , bad, {name}=“alcohol per week” and {change} >=0 , bad, {name}=“waist” and {change} >=0 , bad, {name}=“fruits per week” a…

Hello @DeepikaChoda and @Deep ! Have you been able to find a solution for this or are you still working on this issue? The mismatch aggregation error happens because you are pulling an aggregated field and a non aggregated field from the same row. What this means is you could try nesting your cond…

Hello @WLS-D , I have not yet found a solution for this issue.

Hello @DeepikaChoda ! Here is an example of how I was able to workaround the mismatch aggregation error: diff calc: sum(Sales) - sum(Profit) calc1: ifelse( Segment = 'SMB', 1, Segment = 'Enterprise', 2, Segment = 'Strategic', 3, NULL ) Calc2: ifelse( sum(Calc1)= 1 AND margin <= 50, 'bad', su…

Hi @WLS-D , This works on sum function, but when it comes to average function we are getting different. Here in my calculation Change= Before Average - After Average when i tried to implement your logic I am facing two problems , Getting an error of "Custom aggregation fields cannot be as a Dimen…

Hello @DeepikaChoda ! Thank you for following up, can you share your calculated field?

How to color the values of the table based on the condition on rows and columns

Q&A

Xclipse May 15, 2024, 1:29am 16

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and create a new. (Details on using Arena can be found here - Quick Sight Arena

Topic		Replies	Views
How to define the color of the pivot table based on the condition on colums and row Q&A analysis , filters , formatting , quick-sight , calculations , Business-Intelligence-Engineer	5	105	April 16, 2025
How do I change the background colour of a row in a table depending on a value Q&A developer , quick-sight , qls-amazonQ	10	354	June 27, 2025
Pivot Table Formatting Q&A formatting , quick-sight	2	690	December 6, 2022
Conditional formatting not working in pivot tablet Q&A quick-sight , visuals , dashboard , Business-Intelligence-Engineer	6	544	October 16, 2023
Conditional formatting (color a row) based on values from another column in the dataset Q&A analysis , formatting , quick-sight	1	1153	May 8, 2023

How to color the values of the table based on the condition on rows and columns

Related topics