rank problem

[vikasmahajan]

Dear All

I have brand and month as dimension now I want to calculate RANK for every month  following are my expression for overall

AGGR(RANK (SUM (Values), 4),BRAND)

I wan to calculate Brand wise / Month wise  Rank

How Do i acheive the same.

Thanks.

Vikas

Hello

Sample file works with  following expression

Aggr(num( rank( sum(Value ), 4)),BRAND,MonthName)

But same not working in LIVE report is not display.

Regards

Vikas

[kumarnatarajan]

Hi,

Try This one:

Ex: aggr(NODISTINCT Rank(Sum(Values)),FieldName)

FieldName =  Your Group Name / Month

[er_mohit]

write

num( rank( sum( Values), 4))

or

num(aggr( rank( sum( Values), 4),Brand,Month)

[#4]

rank(aggr(NODISTINCT sum(Values),Brand),4)

[vikasmahajan]

Thanks for reply

Both are not working

Vikas

[kumarnatarajan]

Hi Vikas Mahajan,

Send sample file

[rustyfishbones]

Maybe this video could help you

https://www.youtube.com/watch?v=MypobUg-HkE&feature=youtube_gdata_player

[er_mohit]

i tried above code for my components and mat id to find sum of no. of quantity and it works fine for me,here look acc. to my example

Aggr(num( rank( sum( [No. Of quantity]), 4)),mat_id,components)

try acc. to your field format like this

Aggr(num( rank( sum(Value ), 4)),Brand,Month)

hope it helps

[vikasmahajan]

Please find qvw attached files

[er_mohit]

Because you  drag your dimension month for that reason it gives you nul value and where it find the value show that

now you simply write this code

num( rank( sum( Value), 4))

hope it helps