show max value of records in pivot chart : calculated dimention

[andriesb]

I would like to show instead of this list, only one line and in column km/draaiuren only the max (value) of all these lines.

I though as all these line refer to the same 'object', a calculated dimension would do the trick : however the code =max(km.inhoud) returns an 'error in calculated dimention' . Do i have to define the 'scope' ?

In this example I would expect the result to have a single line with the value km/draaiuur to show '9741'

[lironbaram · Accepted solution]

hi in calculated dimension with max function

you need to use aggr function

something in the lines of

aggr(max(km.inhoud),middelen.naam,midmiddele,bedrij)