Skip to Content
0
Former Member
Sep 16, 2014 at 12:27 PM

formulay to display max

31 Views

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