HELP: Count number of companies once in table

[Anonymous]

Hello all,

I am having a silly problem trying to count different companies in a table.

Imagine that I have a table with the following values

CompanyType	Company
Bank	ING Direct
Bank	BBVA
Telco	Telefonica
Insurance	BBVA
Insurance	Sanitas

Note that BBVA appears twice. I need to build a table that counts the distinct companies only once in the whole table. See the desired table:

CompanyType	Count
Bank	2
Telco	1
Insurance	1*

* I do not want to count BBVA again as it was allready included in the first row.

I had tried many different things using a combination of above and set analysis but I could not make it work.

I will be happy if you can help me to find a solution.

Regards and thanks in advance

[Anonymous]

Hello,

After doing the final test inside the customer environment and his data we did finally certificate this change.

Thanks a lot for your valuable support

Kind regards,

Javier