Filter

Let’s use a filter to spot-check the XLOOKUP formulas from the previous section.

Creating a filter

1. Click on the icon in the movieTitle column header.
2. Select Filter.
3. In the new right window pane, click into the Search box.
4. Search for toy story and select Toy Story (1995).
5. Search for jumanji and select Jumanji (1995).
6. In the popup search menu, click on OK.
7. Similar to formulas, notice that we need to click Apply to run our filter. There’s also an indicator in the filter pane that there are pending updates to apply.
8. Click Apply and look at the results. As expected, all the rows with Toy Story (1995) have movieId of 1. All the rows with Jumanji (1995) have a movieId of 2. Cross-checking those are the correct movieIds on the movie tab helps verify that the lookup worked correctly.

Filtering doesn't impact calculations

Similar to Excel and Google Sheets, filtering in Tabmega doesn’t delete underlying data. It’s just a mechanism to view a subset of the data. Formulas and pivot tables still use all the underlying data as we’ll see shortly. If you want to delete certain rows see Delete Data

Filter by condition

Tabmega currently doesn’t have controls to filter by condition, such as filtering for movie titles that start with the letter R. But there is an easy workaround — create a formula column that calculates the value of interest and filter on that column. For example, we could create a column called firstLetter with the formula =LEFT(movies.title, 1) and then filter for R and r like the screenshot below.