Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
Just use Count(Tipo)