Group by several columns and count rows

Hi

If I load table in BO, is it possible somehow group the table by some columns and then count rows? I mean, I load normal table with several columns, some column values are equal, is it possible make some grouping and count lines base on this grouping?

Example I have table:

Grouped by Ctry & ID and count ID rows, result:

And at the end, is it possible add this "count rows" in the original table like: