max value of expression for each dimension

[clovati]

Hi all.

I have the column in yellow as input and wish to obtain the measure in green.

2 regione -> 2 values

3 fascia -> 3 values

Thanks in advance!

[marcus_sommer]

Try it with: max(total <regione> abianti) respectively max(total <fascia> abianti).

- Marcus

[PrashantSangle]

Hi,

use max(total<columnName> abianti)

Regards

[clovati]

Thanks! But, if ABITANTI would be an EXPRESSION like sum(abitanti)? How would change max(total <regione> abianti) ?

[jyothish8807]

Hi Clovati,

Try like this:

Exp1:

max(total<regione>abianti)

exp2:

max(total<facia>abianti)

Regards

KC

[rubenmarin]

Hi clovati, can you try this?:

Max(TOTAL <regione> Aggr(Sum(abianti), regione, provincia))

[MayilVahanan · Accepted solution]

Hi

Try like this

=Max(Total<regione> Aggr(Sum(ABITANTI), regione, fascia, provincia)

[ashwanin]

Hi

for Max Abitanti for Regione use expression  :  max(total<regione>abitanti)

and for max abitanti for fascia use :   max(total<fascia>abitanti)