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
