Color previous row in straight table if the same

[pauldamen]

Hi,

I have a straight table with 10 dimensions, what I need is to make the previous text white if this is the same as the current row.

Reason is that for example the first column you see 40 times the same name in the column. So I just want to show the first and make the other 39 rows white.

I already tried the previous and row function but can't get it to work. Any ideas?

Regards, Paul

[sujeetsingh]

You can use Pivot table with expanded dimension  or use some UI trick like text colour white after first cell.

[settu_periasamy · Accepted solution]

Try to use the Above function in dimension background color or TextBackground Like

=if(Above(TOTAL DimName)=DimName,White(),Red())

[pauldamen]

Hi,

Thanks a pivot table will not work because of the data model. I am looking at the text colour trick, but how does the formula look to make next rows white if it is the same.

Regards, Paul

[pauldamen]

Thanks that was it! I was trying it the wrong way around with the dim name first and the above function after the =

[settu_periasamy]

Hi Paul,

It will work in both way..

=if(DimName=Above(TOTAL DimName),White(),Red())