Aggr

[#1]

m having 2 dimensions and 1 expression,

Branch

company

Sum

i need Branchwise  top 10 companies,

m using calculated dimension as =aggr(if(rank(sum(FST_LOAN_AMT)/Denominator)<=11, COMP_NAME),COMP_NAME)

whn i select specific branch, this exp works n i get top 10 comp for each branch ,

but whn i select date calender, it shows less records or it automatically eliminates some of the records,

anybody please help me out into this,

i know thr is some problem with the aggr function used.

[#2]

SUM=Aggr(if(rank(SUM)<=10,Branch,0),Branch,Company)

RANK=Aggr(if(rank(SUM)<=10,Branch,0),Branch,Company)