Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

formulay to display max

Hello Friends,

we are displaying top 5 countries as below using ranking.

CountryCategoryQuantity
GermanyCatA80
ItalyCatB75
FranceCatA60
SwedenCatC10

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

CountryCategoryMaterialQuantity
GermanyCatAMatA80
ItalyCatBMatC75
FranceCatAMatB25
FranceCatAMatD35
SwedenCatCMatE10

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..

CountryCategoryMaterialQuantity
GermanyCatAMatA80
ItalyCatBMatC75
FranceCatAMatD60
SwedenCatCMatE10

Thank you,

suri

Former Member
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question