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]

anybody pls share ur inputs on this..

[Siva_Sankar]

can you share the qvw ?

[#4]

Sorry cant do tht,....

[#5]

if i want to include CYTM flag into this hw cn i do tht,

reason it will cut the dependency from the calender and only show current yr this month data.

[#6]

anybody.........

[Anonymous]

Hello,

what you do is a top 10,

right click on the table, tab Presentation

[#8]

hw cn tht be possible in pivot,

i want top 10 companies branchwise,

i.e

Delhi + top 10 comp + then the respective amt

Mumbai + top 10 comp +  then the respective amt

bangalore + top 10 +  then the respective amt

... same way for all the branches on the basis of sanctioned amt..

[#9]

thnks mohit for reply,

used both the ways,

1. aggr with the date field, it exceeds allocated memory of the object

2. same o/p which m getting by my expression,

m not able to understand y its skipping the some of the records in for top 10,

can u let me know some way so tht i can incluide the current month (MTD) flag defined in the script in the expression, thn might work out....

need ur inputs.

[#10]

Hi,

i think it should rank out Branch and then AGGR on Branch,Company.

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

Thanks

Rajesh