Restricting the number of rows displayed in the straight table

[#1]

Hi,

I have a requirement wherein i need to restrict the display of data to thousand rows in a straight table. As seen i find the option to restrict the number of rows to 100 and not 1000 as in the attachment.Can anyone please let me know how the same can be restricted to show thousand records.

[its_anandrjs]

In your load script add a function RowNo() as Rowno and then reload application and in chart add dimension Rowno as calculated dimension.

=if(Rowno <= 1000, Rowno)

and click on supress when value Is NULL and

and Hide the Rowno Column

[jagan]

Hi,

Check this thread

Paging Implementation for Straight table

Hope it helps you.

Regards,

Jagan.

[#4]

Hi Anand,

As per the above suggestion when the condition on rownum is used other filters would fail.So can you please let me know if there is any alternate solution for the same