Expression

[#1]

hi,

I am using pivot table. in image column if count of green arrow is greater than 2 is shoul show green in status and if count of red is greater than 2 it should show red. how to apply expression in status column.

[CELAMBARASAN]

Then you can use status1 field in the place of trend here.

If(Count(Total<Week123> {<status1={'Green'}>} Dt) >= 2, 'Green')