Implementing pagination without macro

[#1]

HI,

I have data in the following format

Date, Country, City, Sum(Sales)

01-07-2012,A,X,100

01-07-2012,B,Y,200

01-07-2012,C,z,300

02-07-2012,A,X,400

02-07-2012,B,X,500

02-07-2012,C,X,600

... so on

I need to implement pagination. I want to display 100 rows first and then click on say next button to display next 100 rows.

My constraints are

1) I cannot use macros

2) And, the data for that particular date is complete.

i.e. If say for date 01-07-2012 it has 80 rows and for date 02-07-2012 has 50 rows

then I need to display only 01-07-2012 date as i do not want to split data between dates.

Please suggest!!

Thanks!!

[#2]

sort table by date and add a counter to the table "Number"  // on the load script;)

then create variable (on presentation) "Page"

add two buttons"prev" and "next" (add trigger +1 and -1)

make chart with calculated dimension =if(Number<Page*100 and Number>(Page-1)*100,Number) // it is an idea not a final expression

if you'll do that we'll see what to do with your second question

[#3]

Hi Pari,

I have one problem here that if i include a counter in the load script,then the counter value cannot be changed.

But i need the counter to be generated dynamically based on the selections.

I dont know how to achieve this.

[#4]

Hi

send a small sample of data, i'll try to fix it