How to mark double values in a table

[jjbom1990]

Hi guys,

I am not able to fix my problem. I have the following table

it consists out of 3 dimensions and 1 expression. The experssion is not a calculation it is just there to show a value and have certain selections ignored:

=MaxString({<SchoolYear,GroupName, SchoolName>}GroupName)

I would like to have the background color react if the same SchoolYear of the same GroupName is within the table. I would like to give both or one a background color.

I have tried the following background color definition in the expression:

=if(count(total<SchoolYear> distinct [SchoolYear])>1,RGB(255,0,0))

I found this in another question, but it doesnt seem to be working. And I can't figure out what to do.

I tried it both with a pivot table and a straight table

When I am using the pivot and have it all collapsed it gives the maxstring for the schools and color them both red. This is not the desired outcome.

Someone probably has this fixed, or sees the problem within seconds, whilst I have been tinkering with this for quite some time.

Thanks in advance.

[florentina_doga · Accepted solution]

try this

if(count(total <SchoolYear> SchoolYear)<>count(distinct SchoolYear), RGB(255,0,0))

[florentina_doga]

hope his help