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

[Former Member]

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.

[Former Member]

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

[kohesco]

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

[Former Member]

Hi Koen,

Thanks for good approcah!

After find the counter, then will decide no. of tabs also.

Could you explain me create a counter through formula. (Ex- Emp-ID, Emp Name, Emp Salary)

Thanks,

Amrendra

[kohesco]

Hi,

variable 1 = count = =NoFilter(RunningCount(([dimension]Row))

variable 2 = filter =  =NoFilter(If(count<20);"A";"B"))

in report filer on "filter"

[Former Member]

Thanks Koen..

[kohesco]

is your issue solved ?

[Former Member]

Hi Koen,

By using your approach, it was solved.

Thanks.

[Former Member]

Hi Koen,

Is it possible to add tab automatically by using any script on the same webi report.

I don't want to add manually tab and put filter condion again and again.

Thanks,

amrendra

[kohesco]

Hi,

Great news

Please can you set the discussion as "answered".

Grtz

Koen

[kohesco]

Hi,

generation of tabs automatically is not possible.

Grtz

Koen