Forum Discussion

OS11111's avatar
OS11111
New Contributor
4 months ago

CV Conditional Formatting based on membername in row definition A#A111:U1#XYZ:U2#ABC:U3#LMN

I have a CV with a row definition A#A111:U1#XYZ:U2#ABC:U3#LMN, A#A111:U1#XYZ:U2#ABC:U3#OPQ

Please note U3 is LMN and then OPQ. 

This definition is generated by a BR.
I am trying to color a row in the CV if the U3 member is say "OPQ".

I was able to format the color based on U3(using RowE1MemberName conditional formatting) but had to make U3 the first Row Header by saying "Use Default Row Headers" false and setting U3 as Header1.
Want to see if there is some way of saying that without making the U3 as the first row header. 

Thanks,

JS 

 

 

Cube View
  • tomdarnall's avatar
    tomdarnall
    New Contributor III
    4 months ago

    JS,

    Based on your definition, won't you get two rows showing with the same A111 description?  Assuming you'd want the description on these rows to be different, how about having your BR append a :Name(x) at the end of each member filter?  If so, you could have conditional format based on HeaderDisplayText which should be unique based on what the BR passes in.

    Not ideal, but it works.