Find the Max value with field name

[eromiyasimon]

i have some types of subjects for four different students and i want calculate the max marks along with subject name in a chart

here i attached the sample data,

in the given data i want to display the maximum amount of region number along with loan type.

thanks in advance

[sunny_talwar]

Do you have Region and Loan Type as your dimension? May be you need this:

Max(Total <Region> Aggr(Sum(Amount), Region, [Loan Type]))

[eromiyasimon]

HI sunny,

thanks for your reply,

im expecting result like this.

thanks in advance

[sunny_talwar]

Does this look right?

Dimension:

Region

Expression:

=Dual(FirstSortedValue([Loan type], -Aggr(Sum(Amount), Region, [Loan type])) & ' - ' & Max(Aggr(Sum(Amount), Region, [Loan type])), Max(Aggr(Sum(Amount), Region, [Loan type])))

[eromiyasimon]

sunny still im not getting what i expected.

attached the result what im getting now using your expression and Dimension

kindly attach the QVW if you can

[sunny_talwar · Accepted solution]

If you open this link Re: Find the Max value with field name, you will see the qvw attached.

Are you not happy with the numbers you are seeing 24, 78, 98, 76 or are you not happy because you don't see the Loan Type? For seeing the loan type, change the format to 'Expression Default' on the number tab of chart properties

[eromiyasimon]

sunny you are soo helpful,

i wish one day i were like you.

thanks a lot.

May god bless you

[sunny_talwar]

I am glad I was able to help brother .

Best,

Sunny