Transformations

Once you have a Lido table, you can filter, sort, and reshape its data using the toolbar controls or spreadsheet formulas.

The simplest way to filter and sort a table is through the toolbar icons:

Filter — Click the filter icon in the toolbar to add conditions that show only matching rows
Sort — Click the sort icon to order rows by one or more columns

These controls provide an interactive way to reshape the table view without writing any formulas.

Formula-Based Transformations

For more control — or to create new derived tables from transformed data — use standard spreadsheet functions.

Use the standard FILTER function to extract rows matching a condition:

=FILTER(Orders, Orders[@Status]="Pending")

Returns all rows from the Orders table where Status is "Pending".

Use SORT or SORTBY to produce a sorted result:

=SORT(Clients, 2, -1)

Sorts the Clients table by the second column in descending order.

You can combine FILTER or SORT with MAKETABLE to register the result as a new named table:

=MAKETABLE(FILTER(Orders, Orders[@Revenue] > 10000), "HighValueOrders")
=MAKETABLE(SORT(Orders, Orders[@Date], -1), "OrdersByDate")

These derived tables can be referenced by other formulas and extended with additional columns — just like any other table.

Add summary calculations as computed columns:

=COMPUTEDCOLUMN(
  Orders[@Revenue] / SUM(Orders[@Revenue]),
  "Orders",
  "Revenue Share"
)

Each row shows its share of the total revenue.

Start with the toolbar filter/sort for quick exploration, then use formulas when you need to persist the result as a new table
Transformations applied via formulas create new ranges; the original table is unchanged
For more complex transformations (grouping, reshaping), consider using QUERYTABLE to run SQL queries against your tables