ABOUT CONDITIONAL FORMATING

[u2sukumar]

i have a question about conditional formating i.e.
Eg: the data items are in a query subject
      - orderyear
      - ordermethod and
      - quantity

i applied group on orderyear and total on quantity.
now i want highlight the maximum quantity for each ordermethod.

[PRIT AMRIT]

If i got your question correctly, you mean u want to see the Max(Quantity) for the ordermethod irrespective of the 'Order Year' group? If yes, see below

create a Data Item e.g.

Max(Ordmethod):
Expression: maximum(total([Quantity]) for [ordermethod])

Conditional Style Properties:
[Quantity]=Max(Ordmethod)

Then 'Back Ground Color' is 'Red'

If you want to see Max quantity for Ordermethod for Orderyear group then the expression would be

maximum(total([Quantity]) for [ordermethod],[orderyear])

Hope it works for you.

Thanks
P