Skip to Content
avatar image
Former Member

N number of rows, How to show first 20 rows in Tab1, next in Tab2, Tab3.

Hi All,

I have a webi report with n number of rows, i want to resrict report as a max 20 rows in Tab 1, next 20 in Tab 2, same in Tab 3, etc..

Note- don't know total no. of rows, also no ranking concept here..

Ho to do? please suggest me in good way.

Thanks in advance.

Amrendra.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 01:41 PM

    Hi,

    create a counter. add in formula <no filter> Categorize the counter in a variable

    if counter <= 20  set A

    >20 and <= 40 set B

    and so on

    show in each tab everything, but change your filter per tab.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 05:45 AM

    Hi ,

    apply the rownum  function in webi then apply the alter and write the formula like this

    if(rownum<=20)

    please try to tis way I think tis helpful fr u

    Regards,

    Rao

    Add comment
    10|10000 characters needed characters exceeded