Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use expression
=aggr(max(PD Amount),HRG)
this should do
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.
What about this one:
=max( {total HRG} [PD Amount])