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.
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