Skip to Content
0
Jun 30, 2022 at 06:11 AM

Group by several columns and count rows

178 Views Last edit Jun 30, 2022 at 06:12 AM 2 rev

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:

image.png

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

image.png

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

image.png

Attachments

image.png (3.0 kB)
image.png (2.4 kB)
image.png (2.2 kB)