How to get a max value

[#1]

Hi All,

From below table I only want to show the max value of Procedure as a single row in a straight table.

HRG	Procedure	PD	Amount
BMT_AlloRel	Diagnosis - ZZZ	EL	£29,363
BMT_AlloRel	X336-Allogeneic	EL	£299,320
BMT_AlloRel	X711-PROCUREMENT	EL	£32,544
Total			£361,228

Expected output:

BMT_AlloRel

X336-Allogeneic

EL

£299,320

Thanks

[Anonymous · Accepted solution]

use expression

=aggr(max(PD Amount),HRG)

this should do

[tresesco]

Dimension: HRG

Exp1: FirstSortedValue(Procedure, -[PD Amount])

Exp2: FirstSortedValue(PD, -[PD Amount])

Exp3: Max([PD Amount])

While there would be multiple data points against each combination, you might have to use sum() along with max() and firstsortedvalue() and yes aggr() would be required there.

[Anonymous]

What about this one:

=max( {total HRG} [PD Amount])