Split Rows

[sat_tok52]

Hi All ,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

Regards,

Satish

Hi All,

I Have a column called ID it contains 100 rows.As per my Requirement my line chart to show the range of 0-30  rows 1Datapoint  and 30-60 2Datepoint and 60-90 3Datapoint because we considering each 30 rows one datapoint ,and also rest of 10 rows i don't want to show in my chart.

ID	%Value
0-30	63.00%
30-60	75.35%
60-90	85.55%

I am using Class function like Class(ID,30) but it is displaying last last 10 rows percentage also.

Regards,
Satish

[MK_QSL]

=IF(ID > 0 and ID <=30, '1',

IF(ID > 30 and ID <=60, '2',

IF(ID > 60 and ID <=90, '3')))

[sat_tok52]

Thanks for your reply.But I don't want to take Static it should be dynamic.