Max Value

[#1]

Hi all,

I wanted to find a way to calculate the maximum sales value by Category Name i.e. Baby Clothes, Men's clothes. The idea is to see which category sells the most. How can I achieve this?

[MK_QSL]

Max(TOTAL <CategoryName> Aggr(SUM(LineSalesAmount),CategoryName))

[#3]

Thanks.

Assuming I have the following scenario:

Column 1 and Column 2 are expressions. I wanted to show only the max value for Column 1 and max value for Column 2

[#4]

try

firstsortedvalue(empname,-coloumn1)   for max value

[jyothish8807]

Hi Sabah,

What do you mean by max value for Column 1 and 2?

Column1=-58007

Column2=-30264

Am i right?

Regards

KC

[#6]

By max, I mean the max negative number. I.e Column 1 max value is -443009 and max value is -119994

[#7]

firstsortedvalue(empname,coloumn1)   for max value

firstsortedvalue(empname,coloumn2)   for max value

write 2 separate expressions like above u will get