Multi Row Formula - Group by count

[cmohyi]

Hi all. I'm looking to use the multi row formula tool to count some records.

As you can see below, I want to group by Name and Date. I want the first record (min date for each unique Name) to be 1, and count the number of months afterwards. The min date will be different for each name, so I'd like it to be as dynamic as possible. I know I need to group by those two fields but I'm not sure what the expression should be.

Thank you in advance for your help!

Cameron

Name	Date	Month Number
A	3/31/23	1
B	3/31/23	1
A	4/30/23	2
B	4/30/23	2
A	5/31/23	3
A	6/30/23	4
C	3/31/23	1

[alexnajm]

Sounds like a good case for the Tile tool! Here's a workflow to help:

[BRRLL99]

If you group data based on column names , Multi-row formula will sort data as per descending order

You can try this Formula without using Group by

IF [ROW-1:DATA] != [DATA]

THEN 1

ELSE [ROW-1:MONTH NUMBER]

ENDIF

please update column names accordingly as per your dataset