Show max () Dimension In Stright Table

[#1]

Hi,

it's possible to reduce Table 1 to Table 2?

Chatacter is a dimension, and I want to show only the max Character linked to the result of max()

TABLE1

TABLE 2

Thanks,

GM

[Gysbert_Wassenaar]

Try using Dimension Limits to limit the results to the Largest 1 values.

[#3]

Ok,

it's great but it's possible to make an Expression for the same results?

[Gysbert_Wassenaar · Accepted solution]

Yes, you can use the rank function in an if statement. if(rank(something)=1,something)

[maxgro]

see attachment

[#6]

Thank's very helpfull!!!