Hi,
i have some data where i want top 5 denomination of 1 customer no. there is huge data with customer no. & it's denomination.
Data is like below.
Customer no. Denomination
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]130[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130039898[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
Pls help in this
rgds
Vishan
i have some data where i want top 5 denomination of 1 customer no. there is huge data with customer no. & it's denomination.
Data is like below.
Customer no. Denomination
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]130[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038377[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038380[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130039898[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD="align: right"]8130038389[/TD]
[TD="align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
Pls help in this
rgds
Vishan