Create top 10 sum

[Former Member]

Hi All,

I have complete Webi report, now want to create top 10 sum of measure after then create top 11 to 25 sum (top 25).

Can anyone suggest me how to create top 10 sum in Web report (BO 4.0).

Please see attached doc. & let me know.

Thanks & Reagrds,

[Former Member]

Hi All,

Can you please reply on my above mail?

Regards,

[vinay_lohakare5]

Hello Manoj,

Create a variable for the top 10 and top 25.

To get the sum of 11 - 25 , subtract top 25 - top 10.

I dont know how you can insert it in between, but you can have seperate table at the top or insert the cell to the right to show the top 10 or 25 measures.

Thanks,

Vinay

[Former Member]

Thanks for reply. but how to create variable for

top 10 sum & top 11 to 25 (top 25) sum?

[vinay_lohakare5]

Hello Manoj,

Use the rank function to get the top 25 rank.

Create the variable which will sum data for rank 1-10 and another variable which will sum the measure for rank 11- 25.

Syntax: 

Rank(measure;[ranking_dims][;Top|Bottom][;re

set_dims])

Thanks,

Vinay

Example:

Rank([Revenue];([Country]))

Country   Revenue  Rank

India        1000000  1

US           1000       2