Customise display of number of rows in pivot table

[renjithpl]

Hi all,

I have a pivot table with more than 20,000 row items. Is it possible to have some functions like showing

1. First 5000 entries, then,

2. From 5000 to 10000 entries

3. From 10000 to 15000 etc...............till 20000

Any ideas?

Renjith

[Sokkorn]

Hi,

Try this post : http://community.qlik.com/thread/35966

Regards,

Sokkorn Cheav

[renjithpl]

thanks for the response!! this will give you a rank, i want data "between" not from top. . Thanks...

[jagan]

Hi,

Try this

sum({$<Product = {"=rank(aggr(sum(Sell),Month))>= 2 AND rank(aggr(sum(Sell),Month))<= 10"}>} Sell)

2 and 10 are start and end values to be displayed.

Regards,

Jagan.