Max Function

[#1]

Hello Friends

Using the below value I am trying to create a pivot table top in each subject and score.

I tried the max function =Max(Score) in the expression and Class in the dimension its fine but when I add Name in the dimension the chart showing the wrong result.

Could you please advise me, how to implement this in a pivot table.

LOAD * Inline [

Class, Name, Score

English, James,5

English, Sneha,6

English, Ram,10

Maths,Troy,1

Maths,Khan,5

Maths,Alif,8

Maths,James,9

Science,Sneha,5

Science,Ram,7

History,Ram,9

History,Khan,3

History,Troy,1

History,James,2

];

Regards

Joe

[anbu1984]

=Aggr(Max(Score) ,Class)

[#3]

in the expression write : AGGR(Max(Score),Class)

dimension : Name

[tresB · Accepted solution]

Dimension: Class

Exp1: FirstSortedValue(Name, -Score)

Exp2: Max(Score)

[martinpohl]

use

max(total <Class> Score)

Regards

[#6]

Hi Anbu,

Thanks for u r reply but the result is wrong for instance Ram is the topper in English but as per your result James.

Regards

Joe

[#7]

Hello All,

thanks a lot for your suggestions,

tresesco, your answer is worked,

Thanks again