If you prefer to use a pivot table, you can do this in both Excel and Sheets, and both give you the option to choose what is displayed in the columns and rows, whether you apply filters ...

There is an option to insert a pivot table on a new sheet or an existing one. We recommend adding pivot tables to another sheet to avoid any confusion. As mentioned, you can also create a custom ...