MAX of a date field

[#1]

I have a field that is set as date.

If i use the following instruction in the expression of a pivot table it works

max(date_field).

If I use the same instruction in the dimension of the pivot I get an error message.

I want to use the result for an aggr fuction, but for the moment my first problem is to make the MAX fuction to work

Anyone can help?

THanks

Andrea

[alexandros17]

Ciao Andrea,

ogni espressione funziona sulla base delle dimensioni inserite in un oggetto, se inserisci una funzione di aggregazione (Max) nella dimensione, sulla base di cosa dovrebbe essere calcolato il max?

Spiegami cosa vuoi fare e dove, cercherò di aiutarti

[jerem1234]

You can't use aggregation functions in a calculated dimension (i.e. max()). You can use a workaround with the aggr() function. Something like:

aggr(max(date_field), FIELD)

Hope this helps!