how do we retrun first 5 records in crosstab webi

[Former Member]

Hi All,

Iam using BO 4.1 sp07

SQL 2014

webi reports, I want to show only first 5 records in a cross tab, no top or bottom but first 5 records.

Any suggestions?

[Former Member · Accepted solution]

I Could resolve this, created a variable, running count on a stock level and added filter to cross tab using that variable as runningcount(stocklevel)<=5.

[Former Member]

I had tried that but it returns wrong results

See before applying filter

After Applying running count filter

What could be the reason

[amitrathi239]

drag runningcount variable in the crosstab and see if it working or not.

[Former Member]

But I have to use it on dates as I want data for first 5 dates

[amitrathi239]

if you want to use on dates then use date object in the running count.

=runningcount([date object])

[Former Member]

yes that's what I used but getting wrong results

[amitrathi239]

create variable runningcount=runningcount([Your object])

Apply filter on runningcount variable where less then or equal to 5 to get the first 5 rows.