How to find group count in datatable?

Help Studio
, ,
1

how to find group count in datatable ? i have a tatable i need to groupby count “Unit” and “Month” below i mention datatable and my output datatable i have already create my output datatable template.

The image shows a table listing various units, PO numbers, months, descriptions, and quantities for different orders. (Captioned by AI)
The image shows a table listing various units, PO numbers, months, descriptions, and quantities for different orders. (Captioned by AI)609×641 15 KB

The image is a partial spreadsheet showing unit data across May to December, with various entries for some units in May through August and blanks in the remaining months. (Captioned by AI)
The image is a partial spreadsheet showing unit data across May to December, with various entries for some units in May through August and blanks in the remaining months. (Captioned by AI)777×390 6.8 KB

i need output for above format

2

domsmgtmeet22 is seeking assistance on how to find the group count in a datatable by Unit and Month . They have shared images of their current datatable and desired output format.

3

HI,

How about the following sample?

image
image1138×1902 140 KB

Sample
Sanple20240902-1.zip (17.3 KB)

Regards,

4

your work flow is correct. i need count of month

5

HI,

Can you share expected result?

Regards,

6

The image shows a spreadsheet with columns for Unit, PO Num, PO Date, and Month, containing multiple entries all under the unit "ECB" with purchase order numbers and dates predominantly for July 2024. (Captioned by AI)
i need count of month out put is 11 ecb july month

7

HI,

The above sample outputs sum value of each Unit and Month. Doesn’t this work for you? Do you need any other format?

image
image895×156 4.39 KB

Regards,

8

i need count format not sum

9

All right. How about the following sample?

Sanple20240902-1 (2).zip (17.2 KB)