Remove row from TableList

[#1]

All,

I build a 'new sheet object' of type Table List. It is populated  with data from Excel. Mistakenly, I am loading the last row, that is Total Revenue, and should be calculated separately but is not an item in the list.

Is it possible to remove an item from the list after the list is built ? On right click, it is possible to remove the whole object, but i cannot find how to eliminate one row.

Regards

[#2 · Accepted solution]

Hello,

If you can attach the excel file will be much better but you can try a table list using an expresion and the expresion should be something like this:

If(MyField<>'Total', MyField)

or

If(Len(Trim(MyField))>0, MyField) // If the total row is null or is an space.

Best Regards.