How to compare numbers between rows in a table for specific dimension

[pranaview]

Hello,

I have a requirement where i have to check if the numbers for a group matches or not and based on that assign green/red color to the text in a straight table. Will be more clear from below example

Code      Date                 Amount

1            7/10/2022        500

1            7/17/2022        500

2            7/5/2022           878

2            7/11/2022        880

3            7/20/2022        350

3            7/25/2022        350

So, in the above example, Amount on two different dates matches for Code 1 and 3 and hence all 4 rows corresponding to these 2 codes needs to be shown in Green (only Amount column in green is enough) and for Code 2, the Amount doesn't match and hence these two rows will be red. Hope the requirement is clear enough.  I am looking to handle this in the front end table .

Any tip or suggestion will be appreciated, thanks.

[justISO · Accepted solution]

Hi, maybe

if(aggr(nodistinct count(distinct Amount),Code)=1, green(), lightred())

[pranaview]

Hello, this expression worked. thanks!