Forum Discussion

Florence_Marie's avatar
Florence_Marie
New Contributor III
3 days ago

Conditional format based on Row Member Name and Row Headers hidden

Hi the Community!

I need to show, in a cube view, the subtotals of my rows, showing the dimension members presented in the Row1 header (I have 2 rows in this case). To achieve this, I built an UD8 dynamic calculated member and that works pretty well - when on the Row2 base members, then it shows the description of the members, if i am on the Total member, then it shows the member descriptions of the dimension which is set on the row 1). 

However, sounds quite basic, but I need to set another format on those subtotals, so I used the Conditional format based on the Row Member names (If RowE1MemberName ...), what is working perfectly fine, until I hide those row headers - in this case, then the conditional format doesn't work anymore !

How do you achieve this kind of basic requirement in this case? Any idea would be very helpful :)

Thanks is advance,

Regards,

Florence

 

 

No RepliesBe the first to reply