count items in subset

[bansefi01]

I need to count the different items in a data subset in a data array like the following:

ID	Tipo	Amount
1	Daño Total	$3.00
2	Daño parcial	$5.00
3	Daño elevado	$1.00
4	Daño elevado	$7.00
5	Daño Total	$10.00
6	Daño Total	$3.50

The answer I would expect is as follows:

Tipo	claims	Amount
Daño total	3	$16.50
Daño Parcial	1	$5.00
Daño elevado	2	$8.00

=count (distinct tipo) will give me 3

Can you help me please with the formula for COUNTING the claims at each sub set of TIPO ?

thanks

[trdandamudi]

Is this what you are looking for ?

Data:
Load * Inline [
ID,Tipo,Amount
1, Daño Total, $3.00
2, Daño parcial, $5.00
3, Daño elevado, $1.00
4, Daño elevado, $7.00
5, Daño Total, $10.00
6, Daño Total, $3.50
];

[vishsaggi]

Just use Count(Tipo)