limit top10 rows in a block

[system]

This one is amazing!

120×120 10.4 KB

I have a table and Chart both having Ranking for Top 20 Budgeted Departments. Sometimes there may be 50 departments which have same budget in that case the table expands and overlaps with other blocks below. To avoid this I wanted to show only 20 departments maximum even when there is a tie. How do we achieve this inside a Webi? Thanks in advance. Diana_baker (BOB member since 2005-03-18)

I’m not pretty sure how it works but when you have a tie is a very good thought.

Thanks!!

---

drserguey (BOB member since 2010-03-01)