Skip to Content
0
Former Member
Aug 05, 2016 at 12:50 PM

How to get top 50% in a data

34 Views

Hi,

I have got a table as shown below in webi for example

Rep Name Rep No Total Revenue

a 1 5000

b 2 4500

c 3 4000

d 4 3500

e 5 3000

f 6 2500

My question is how to get top 50% from the above data in the webi report. i.e. I need only first three rows.

Thanks,

Yaswanth.