I have a crosstab with months in columns, organizational units in rows and a measure based on percentages. I have summaries for both columns and rows.
The query contains a dataitem "My Target" (aggregation functions set to 'None') which has the value 0,05.
I have created this conditional style:
[qryReport].[My Measure] > [qryReport].[My Target]
I then added "My Target" to the properties of the Month dataitem in columns.
The conditional style works fine for both the fact cells and the rows summary, but not for the columns summary.
If I change the conditional style to:
[qryReport].[My Measure] > 0,05
it works fine, but since I use the target value multiple times in the same report I would prefer to store it once in a dataitem instead of hardcoding it every time I use it.