How to Filter Column values based on rows

Swapna_R · April 27, 2021, 1:53pm

Hi Team,

I would like to highlight the cells in Production defect column which has Cause by release row values like WR-Jan-07 in the below report.

Thanks in advance

Regards,
Swapna

martins.vanags · April 28, 2021, 1:02pm

Hi @Swapna_R

Starting from eazyBI version 6.2.2 you could apply cell conditional format rules to the whole row.
You could use a custom formula that checks the level name for the row and then color them.

This is the custom cell formatting formula I used in my example (see attachments below):

CASE WHEN
[Color].CurrentMember.level.name = "Color" --checks the level name for the row.
THEN
"Yellow"
END

Martins / eazyBI