Filtering the Records

[#1]

Hi,

I have a straight table with the following records.

Sr No Value

1 30

2 50

3 40

4 20

5 10

6 24

The Value field (Made some calculation in the straight table using some other fields).

I want only 4 records out of 6. Can any guide me.

Thanks,

[renjithpl]

Hi tims,

Try this in your dimension.... (your_Expression is nothing but your calculation)

=aggr(if(rank(total your_Expression)<=4,[Sr No],'Other'), ,[Sr No])

Revert back if any queries

Ren