Top3 revenue sum to show in text object

[satishqlik]

Hi,

I have a scenario pls help

Department, revenue

A, 100

B,  600

C,  300

D,  400

E, 500

F,  400

G, 600

I want to show in object top3 sum 600+500+400=1500

Any help??

[Aurelien_Martinez]

Hi,

=RangeSum(Max(Aggr(Sum(amount), Department), 1), Max(Aggr(Sum(amount), Department), 2) , Max(Aggr(Sum(amount), Department), 3))

[vinieme12]

I want to show in object top3 sum 600+500+400=1500

Are you sure what you want is correct?

Your top 3 departments by revenue are , B,G and E, so revenue of top 3 departments should be 1700 = 600+600+500!!

Department, revenue

A, 100

B,  600

C,  300

D,  400

E, 500

F,  400

G, 600

[#4]

Hi,

try

max(amount,1)+max(amount,2)+max(amount,3)

[hemachandran]

Hi sathish,

can u try this expression

=rangesum(max(amount),max(amount,2),max(amount,3))