"Mind blank" on finding Max Value in a straight table

[timsaddler]

Hi all

I noticed a thread to calculate this in a script, but is it possible to do this in a chart straight table calculation?

Here is the example data :-

Customer A/c Name	Project Number	Sales Revenue	Multiple Quote
Smith	1234567	22,626.20	4
Jones	1234567	22,576.60	4
Brown	1234567	21,956.44	4
Black	1234567	13,290.00	4 I

The business have quoted the same (Project number)job to 4 different customers

I need to show the largest quote only  - in this case 22,626.20

Thanks in advance

[Chanty4u]

=Max(( projectnumber),customername,salesrevenue)

[MayilVahanan]

HI'

Try like this

Dimension:

Project Number

Expression:

Sales Revenue

=Max([Sales Revenue])

Customer

=FirstSortedValue([Customer A/c Name], -([Sales Revenue]))

Project Number	=Max([Sales Revenue])	FirstSortedValue([Customer A/c Name], -([Sales Revenue]))
	22626.2	Smith
1234567	22626.2	Smith

[Chanty4u]

u can

AGGR( nodistinct

     MAX(

           AGGR( nodistinct

                    <formula>

                    ,Customer, Stage)

     )

, Customer)

[timsaddler · Accepted solution]

I've ended up using this procedure :-

To Find Max value in a One Column