Rank and Over All Rank

[sat_tok52]

Hi All,

I have to display Over all rank column beside my rank column,suppose When user selected a filter the rank column display ranks based on the selection it is working fine for me ,but i have to show over all rank  need to be a display like below.

Before Filter Selection:

Zone	Emp Name	Rank	Over All Rank
East	A	1	1
West	B	2	2
East	C	3	3
South	E	4	4
North	F	5	5

After Filter Selection(If user selected east zone)

Zone	Emp Name	Rank	Over All Rank
East	A	1	1
East	C	2	3

I written logic like below it's not working.

Aggr(Rank(Total Sum(Sales)))

Any help...

Thanks.

[Kushal_Chawda]

try this expression

Overall rank

=rank(total sum({<Zone>}Sales),0,4)*avg(1)

for rank

rank(total sum(Sales),0,4)*avg(1)

Note:  Please check 'Suppress zero value' for expression.

[Taoufiq_Zarra]

for Rank

=Rank(total sum(Sales))

for Over All Rank

AGGR( RANK(total sum({1}Sales)),Zone,[Emp Name]) 

output:

[Kushal_Chawda]

it's better to define field for which we need to exclude selection instead of using {1}, otherwise it will not consider selections of field which is mandatory like period selection