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