Skip to Content
avatar image
Former Member

how do we retrun first 5 records in crosstab webi

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 21, 2017 at 10:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 20, 2017 at 12:13 PM

    create variable runningcount=runningcount([Your object])

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2017 at 12:30 PM

    I had tried that but it returns wrong results

    See before applying filter

    After Applying running count filter

    What could be the reason

    Add comment
    10|10000 characters needed characters exceeded