Highlight max value in a subtotal row of a crosstab

[sanndeb]

Hi guys hope you all are fine....

I'm totally new to SSRS 2008 & stuck in a problem. So please help. :)

I have a crosstab report from northwind & I'm able to heighlight max value for each row with the expression below :

=iif(Fields!SalesAmount.Value = Max(Fields!SalesAmount.Value, "Year2"),"LightBlue","Transparent")

where "Year2" is my row group against year. There is also a column group against "Region" & the data is of sales amount. Now the code will not work for highliting the max for the subtotal row. So how do I highlight the max value for the subtotal row also.

Please see the following pic for more details :

[ck9663]

Do you want it to be highlighted because it is the highest or you want to highlight all the sub-total row? Can you just check if the description/year = "Total" then change the colors accordingly?

Good Luck!!!

~~ CK

[sanndeb]

@ck9663
I want to highlight only the max value, in this case the last value, not the total row....

[ck9663]

You might need to do something like iif(sum(fields) = max(sum(fields)),"highlight","not highlight"). It's obviously a pseudocode, so you have to modify it accordingly.

I'm not sure if double aggregation will work, though. Give it a try.

Good Luck!!!


~~ CK

[sanndeb]

Not really :( It gives error saying you can't use aggregate function inside another :(

[ck9663]

You might be able to do that using a different query (dataset), maybe.

Good Luck!!!


~~ CK