how to do this on a pivot table

[ali_hijazi]

Dear I got a pivot table with dimensions Country, Shop

and showing the sales variance

and in another expression I'm displaying a column with an image which is either green if the variance is positive or red if the variance is negative

Now if the country dimension is collapsed I'm getting a greed image if the total is positive or red if the total of variance is negative

However what I want is the following:

if under the country the variance of some shops is nevative and other positive then display a third image which is gray otherwise if all vairances by shop are positive then show green else show the red image

Check attached image for more elaboration