cancel
Showing results for 
Search instead for 
Did you mean: 

how do we retrun first 5 records in crosstab webi

Former Member
0 Kudos
150

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?

View Entire Topic
Former Member
0 Kudos

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.