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 ...

and uncheck "Formula Bar," "Gridlines," and "Headings" to make your dashboard look less like an Excel sheet and more like a professional data dashboard. Then, hide your PivotTable tabs ...