How to limit the number of rows in table based on button click

[#1]

hi

I have a table with several rows and columns(a, b, c) and I have 3 buttons.The c column will be set to ascending order. When I click first button, I should get first 3 rows. when I click second button, I should get first 5 rows and so on. How can I achieve this ?

Thanks,

[sibin_jacob]

Hi,

We can limit rows in a table based on first expression only.

You may use one variable. Based on button click you can set value of that variable(3 or 5).

In your table properties dimension limit tab->check on restrict values->

select shiw only -> First

Please see the attached screen shot.

Thanks

Sibin