How to get data from csv file to design pie chart

ManikantaC

hi friends
iam very new to birt i want to design pie chart through csv file the requirement is iam having one csv file in that so many duplicate records is there through birt function i want to calculate the all dupllicate records value and i want to get top 14 records and remainig will be others in the pie chart that to for some records there is space so iwant to trim and i want calculate.
plase help me as early as possible frnds

the format of csv file is

SERIES_DESC COUNT

AX T1 POST 238
COR T1 POST 190
SAG T1 POST 143
Ax T1 +C 77
Cor T1 KM FAT 67
Ax T1 POST 65
SAG T1 +C 64
COR T1 +C 60
Sag T1 KM FAT 58
Sag T1 POST 52
Ax T1 SE +C 51
AXIAL T1 POST 48
Ax T1 KM FAT 48
Sag T1 +C 48
Ax T1 SE POST 44
COR T1 SE +C 42
3D-BOT 41
AX T1 +C 40
COR T1 GAD 40
AX VIBRANT MULTI +C 40
3D-TOP 38
AX T1 GAD 37
AXL LAVA +C DYNAMIC 36
COR T1 POST GAD 36
Ax Vibrant MultiPhase +C 36
O-Ax T1 SE+C 35
Sagittal T1 post 35
A1. COR SE T1 W 33
T1 AX+C 33
Cor T1 SE+C 33
COR T1 SE+C 33
T1 AX POST 33
AX T1 FS POST 32
AXIAL_T1_WITH_GAD 32
AX T1+C 32
SAG SE T1 +C 31
T1 SAG+C 31
Ax T1+C 30
SAG T1 FS POST 30
Ax Vibrant MultiPhase 30
Dynamic-GAD 30
SAG VIBRANT +C 30
Ax LAVA-XV BH MultiPhase 29
Cor T1 +C 29
COR T1+C 29
T1 AX +C 29
T1 SAG +CON 28
lava post 28
AX DYNAMIQUES 27
COR T1 C+ 27
T1 CORONALS W/FS C+ 27
AX T1 POST GD FLAIR 26
axial T1 / GAD 26
SAG_T1_WITH_GAD 26
Cor T1 Post 26
CORONAL_T1_WITH_GAD 26
COR T1 POST 26
COR T1 F/S POST 26
AX T1 FS +C 25
AX T1 SE+C 25
T1 COR POST 25
cor +c fsat 25
ax +c 25
T1 COR+C 25
SAG T1 POST GAD 25

mwilliams

Hi Manikanta,

So, you want the top 14 of these by "Count" in a pie chart, nothing else? No grouping of like "Series_Desc"?