Incremental String (Excel Formula) based on Location

[Mert]

Hi,

Here is my dummy data:

Location	Category	Qty	Budget
Los Angeles	Rev	4	100
Los Angeles	Exp	6	170
New York	Rev	2	200
New York	Exp	4	250
London	Rev	7	325
London	Exp	6	325

What I would like to achieve is to add a field and add string (Excel formula) to every cell starting as C5*D5, incrementing based on Location. Please see below:

Location	Category	Qty	Budget	Formula
Los Angeles	Rev	4	100	C5*D5
Los Angeles	Exp	6	170	C6*D6
Los Angeles	Exp	6	120	C7*D7
New York	Rev	2	200	C5*D5
New York	Exp	4	250	C6*D6
London	Rev	7	325	C5*D5
London	Exp	6	325	C6*D6

Any suggestions please? Thanks!

[PhilipMannering]

HI @Mert 

Not sure exactly what you're going for here, but does the following help?

[DataNath]

If you just want the formula generating to then use downstream/export somewhere then this will start again at C5*D5 for each location:

Let us know if the requirement is something different - happy to revisit!

[binuacs]

@Mert Another way of doing this with the tile tool

[Mert]

@binuacs and @DataNath thank you both for your prompt and working replies.

@PhilipManneringthank you for your time as well however I need a workflow that approaches the new field incrementally per location.

[PhilipMannering]

No worries @Mert. As long as the community as a whole has provided you with a working solution, that's the main thing!