Find the rank of multiple ranked fields

[9917mark]

Morning to all,

Could I please get some help with the following.

I have 4 unique ranking calculation which give me the respective rank based on

• Qty of Tansactions (Rank Trans)

  • only(aggr(nodistinct rank(count(Partno),4,1), Partno))

• Qty Sold (Rank Qty)

  • only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno))
    

• Sales Value (Rank SalVal)

  • only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno))
    

• GP Rands (Rank GPR)

  • only(aggr(nodistinct rank(sum(RProfit),4,1), Partno))
    

All of which are working perfectly.

What I require is to get an overall ranking based on all of the previous rankings. (Rank Over)

Where currently I can only get the combined sum of the rank.

ie in the Rank Over the results should display :

Your help will be appreciated.

[sunny_talwar]

Have you already tried this?

Rank(Expression1, Expression2, Expression3, Expression4)

[9917mark]

I have thanks, as well as adding the four ranks together and then doing an overall ranking on that result.

[sunny_talwar]

Sorry, that is what I meant

Rank(RangeSum(

only(aggr(nodistinct rank(count(Partno),4,1), Partno)),

only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),
only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),

only(aggr(nodistinct rank(sum(RProfit),4,1), Partno))))

What do you do when you add this as one of your expression

[9917mark]

Ok no laughing now,

I modified your suggestion to get the ranking to work. (Rank Over)

Rank(Total(RangeSum(

only(aggr(nodistinct rank(count(Partno),4,1), Partno)),

only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),

only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),

only(aggr(nodistinct rank(sum(RProfit),4,1), Partno)))),4,1)

And it works perfectly except for one small problem.

It is ranking in the reverse order ????

When I use the example you have posted I get (Sunny)

@

Re: Find the rank of multiple ranked fields

Sunny Talwar

Thanks for the patience

[sunny_talwar · Accepted solution]

Try this

Rank(Total(-RangeSum(

only(aggr(nodistinct rank(count(Partno),4,1), Partno)),

only(aggr(nodistinct rank(sum(OrderQty),4,1), Partno)),

only(aggr(nodistinct rank(sum(TotalSales),4,1), Partno)),

only(aggr(nodistinct rank(sum(RProfit),4,1), Partno)))),4,1)

[sunny_talwar]

Ok no laughing now,

Why not? Laughing is a good thing

[9917mark]

You are a star

Re: Find the rank of multiple ranked fields

stalwar1

Appreciate all the help with this.