Cal. Dim

[#1]

Hi guys

I have a table like :

Id Type

1    A

1    B

1    C

2    A

2    B

3    A

4     B

and i need the output in a straight table like

Type      Count(Id)

A               3

B                3

A + B         2

A+B+C         1