Hi, I need to compare a measure between a level in a dimension and his parent in a report studio crosstab.
The dimension I want to compare is commercial structure ( estructura comercial in the image)
and I want to compare for example the first row of the image
(cuentas centralizadas) and the total ( estructura comercial) , if the first measure is bigger than the total
( is a percentage) I have to put it in red color.
Ive tried to do directly but it doesnt work, also I´ve tried to insert a hidden column and compare , using total,
the function tuple() and some other things but it doesnt work also.
The data comes from a cognos cube.
Any help would be really appreciate.
Thanks.
Did you try applying conditional formatting? You should be able to select a row and base the condition on the total. There you can choose to color it red based on the "condition"