How can I achieve the value % requirement in Webi 4.1

Hi Experts,

I got stuck with certain requirement which has to be fulfill using webi 4.1. Environment here is BO 4.1SP5 having backend SAP BW 7.0.

Let me explain you with follwoing eg:

Suppose I have to create top 8 vendors report out of 15 vendors having value as measure as shown below:

Top 8:

Vendors Value a 523 b 487 c 369 d 245 e 157 f 105 g 100 Total: 1986

Full Vendor List:

Vendors Value b 487 a 523 e 157 f 105 g 100 c 369 d 245 i 98 j 99 h 82 m 83 k 48 o 69 q 71 p 52 Total: 2588

Now my requirement is I get top8 total which is 1986 divide by Total I get for full vendors which is 2588 and want to convert in percentage.

= (1986/2588)*100 = 76.73.

Now if I make a variable of total sum I get same result but when I try to divide by TOP 8 total it gives me a wrong. answer.

And Top 8 list will get change as per the selection dynamically.

Please guys help me out..

Thanks in advance.