Hi @Jennifer,
Probably need an example, but there are ways of creating a filter menu at the top of a page that filters all views on the page. I’ve heard Knack Toolkit Library caters for this, but I’ve never used it myself.
If you want to export the data out of Knack and into Excel or Power BI for laying out how you’d like, I have a connector solution that you can explore here: Knack Connector for Power Query (Excel/Power BI).