limit rows in pivot table

[surajap123]

Hi All,

I want to limit the no. of rows in the pivot table.

Currently you can see there are 9 products. I want to show 4 products in each pivot table, ie. in first table i want to show A to D Product, in 2nd pivot table E to H Products details and in final table the remaining Product ie, J.

Please help

[pradosh_thakur]

what about

in table1

expression1= if(rowno()<=4,your expression)

in table 2

expression1= if(rowno()>4,your expression)