calculate highest ranked sales excluding the selected company

[arjunmadhusudan]

Hi,

I have data as below

Company    Sales

A                  1000

A                     400

B                    500

B                      20 

C                  2000

D                    400

D                      20

I need to calculate     Sum of sales selected company /   Sales of company with highest sale from the remaining list ( not selected)

Regards,

Arjun

[arjunmadhusudan]

Raju,

You have handled the max condition in the load script , right ?

[sunny_talwar · Accepted solution]

Care to respond me back here?

exclude selection and find top ranked sales

[qv_testing]

Then try this,

Exp1: Sum(Sales)

Exp2: IF(GetSelectedCount(Company)=0, Max(Sales), Max({<Company=E(Company)>}Sales))

[thevingo]

hi Arjun,

as stalwar1‌ already mentioned, your all questions are answered, please close this thread