...
03:17 Use the FILTER function to filter a range of data based on the criteria you define.
What is the Pivot table option?
The Pivot Table View allows you to generate customized reports and get deeper data analysis.
First of all, switch to the Pivot table view.
...
The main functionality of Pivot table view are Fields, Options, Format, Charts and Export.
How to add the field to your Pivot table?
...