Find Max Date

[#1]

I have a table that looks like:

ConsolOrderNo	CustomerName	SalesOrderNumber	MaterialNumber	ConfirmDate	Sales
6478842	ABC	6478842	78301-002450	7/5/2012	56.16
6478842	ABC	6494876	14201-000165	7/9/2012	403.86
6478842	ABC	6496773	70661-016201	7/5/2012	5335.4
6478842	ABC	6496773	70661-016401	7/5/2012	8004.15
6478842	ABC	6497914	71610-026460	7/10/2012	1903.98
6484913	DEF	6482617	71680-015670	7/12/2012	44.64
6484913	DEF	6484913	70020-010418	7/10/2012	29.52
6484913	DEF	6484913	70020-009040	7/9/2012	18.72
6484913	DEF	6484913	70261-001299	7/12/2012	222.12
6484913	DEF	6492896	72000-018400	7/25/2012	31.68

I want to highlight (or make bold) the oldest date for each ConsolOrderDate. So for CosolOrderNo 6478842 I want the date 7/10/2012 in bold and or order 6484913 I want the date 7/25/2012 in bold.

How can I so this?

Thanks,

Stephen

[nagaiank]

Stephen,

Please change the expresion from

Sum(OrderQty)

to

If(Count(Distinct TOTAL <ConsOrderNo> ConfirmDate) > 1, Sum (OrderQty), Null())

and see if you get the result you want.

[#3]

Your the man! Thanks Krish. Works perfect.

Stephen