Group by several columns and count rows

[slvedva]

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:

[ayman_salem · Accepted solution]

Define the following variable:

Count Row: =Count([ID]; All) In ([City];[ID])

..

I hope it helps