Help with Multi-Row Formula

Hello,

Currently having an issue with a multi-row formula, I'm looking at the regional changes of the trucks and I would like the regional count to increase every time the region changes for each truck, as per the example in the excel document highlighted in yellow.

Many thanks for your help in advance,

Regards,

Tristan & Iain

alteryx problem.xlsx

Workflow

Help

Accepted answers

rarmstrong

You can try this

multi-row.yxmd

All comments

JohnJPS

Group by NAME, and try a formula like this:

IIF([REGION] == [Row-1:REGION],[Row-1:SomeNewField],[Row-1:SomeNewField]+1)

... where I'm creating [someNewField] in my formula.

Grouping on Name will get you the re-numbering by name; and the above formula increments each time the region changes.

Hope that helps!

John

rarmstrong

You can try this

multi-row.yxmd

Tristan

Many thanks for your responses - you've solved our problem!

Thanks,

Tristan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703