Filtering data into two tables dynamically

[PickleRick]

I've been trying a variety of multi-row formulas but can't quite figure this one out!

I've got a set of data that is made up of two tables, but with each new dataset the table can be of a varying number of rows. I've managed to flag where the table ends but now am unsure how to filter the top and bottom half so I'm left with two separate tables. I've been trying to use a multi-row formula to create a new filter column 1 and 0 to then use a filter tool to separate but cannot get the formula to work.

Example data (1 is the top tables final row):

Flag	Filter
null
null
null
1
null
null
null
null
null

Thanks in advance!

[bpatel · Accepted solution]

hi @PickleRick ,

is this what you are looking to do? then you can filter based on the "new field" column

hope this helps!

[PickleRick]

Yup that's perfect, and then I can just update the [New Field] for when [Flag] = [New Field] so the bottom line of the table is included in the top half.

Thank you!