How to create a new column and add an identifier after a certain word is reached

Question

Hi! If I have the data below, I want to write a formula that adds an identifier in a new column after the word "Total" is reached. The formula will add the word "Delete" next to Total, 100, and 200. How do I do this? Thanks!

Account

1

2

3

4

Total

100

200

300

Thableaus · Accepted Answer

Hi @jillian

Would something like this work?

Using Multi-Row Formula.

You can group by some field if you need to, if you have multiple totals.

Cheers,