formulay to display max

[Former Member]

Hello Friends,

we are displaying top 5 countries as below using ranking.

Country	Category	Quantity
Germany	CatA	80
Italy	CatB	75
France	CatA	60
Sweden	CatC	10

But when I include material then it is displaying as below.

Country	Category	Material	Quantity
Germany	CatA	MatA	80
Italy	CatB	MatC	75
France	CatA	MatB	25
France	CatA	MatD	35
Sweden	CatC	MatE	10

I need to display material where it has highest 'quantity' as below. but Quantity should display total (i.e 60), not the respective material quantity (ie 35).

Could you please help me the formula definition to display that material..

Country	Category	Material	Quantity
Germany	CatA	MatA	80
Italy	CatB	MatC	75
France	CatA	MatD	60
Sweden	CatC	MatE	10

Thank you,

suri

[kohesco · Accepted solution]

check out document

http://scn.sap.com/docs/DOC-58033

I saw this question popup several times, so I thought a good document was needed.

[Former Member]

Question: How do you determine which Material to show against the country?

[saurabh_sonawane]

try this one

sum(Quantity in ( county))

and after that apply rank