Any way to restrict no of rows display in webi ?

[former_member187884]

Top 3 display coming after applying ranking -

Below is expected display

How can i achieve display of top 3 rows display? Need suggestion?

[former_member607952]

Hi,

How/Why are you displaying Noida in top 3 even though other cities also have the same figures?

By ranking logic, the first result is correct.

If you have a state dimension you could rank cities in a state and display top n state.

-Nikhil

[former_member187884]

Hello Nikhil,

Thankyou for looking into my Question.

I already tried ranking,Rowindex() but not able to restric display to top 3 rows .Could you please share your idea how to achieve expected result?

Regards

Shiv