Conditional Highlighting - Crosstab with Cube Datasource

[Lynn]

I have not wrapped my head around dimensional reporting yet.

If I had a crosstab as below with a cube as my data source, could I create a conditional style that would highlight the higher of the two values in each column? What would that expression be? Comparison of two tuple function expressions or some such thing?

For example, I'd want to shade 56.7% as green at the intersection of Member2 for 2010 while the figures for both 2011 and 2012 would be shaded for Member1 (53.8% and 50.1% respectively).

Code Select Expand


             2010    2011    2012
Member1      42.6%   53.8%   50.1%
Member2      56.7%   53.1%   49.8%


[pricter]

Hi Lynn,

Did you try to create a data item that calculates the maximum value for each column like
maximum([Measure] within set [MembersRows])
Place both this query data item in the crosstab and the measure of the crosstab as nested column.
Create a boolean variable
[Query1].[Measure]=[Query1].[maximum]
On the columns of the measure apply the style that you want.

[Lynn]

Thanks pricter. I'm embarrassed to admit I haven't tried anything at all. Typically I'd experiment before posting for help, but I just wasn't sure where to begin. What you describe makes perfect sense and I'll give that a shot. Thanks very much!!