If you are unable to create a new account, please email support@bspsoftware.com

 

how to compare a measure between a level in a dimension and his parent in rs

Started by sainzvizcaya, 08 Aug 2011 04:40:18 AM

Previous topic - Next topic

sainzvizcaya

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.

leahmarie

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"