From virtually any page list, you can toggle Analyze. This would switch the view of the page list into an Excel-like pivot view where you can set or choose the columns, move columns, and set your filters. You can also group data as well! Once you have the view that you like, you will be able to rename the tab, duplicate the tab or click on the plus sign to generate another analyze view.
What’s New in Microsoft Business Central?: Analyze Page List
Microsoft Business Central’s Analyze Page List is a powerful feature that allows users to analyze large sets of data quickly and easily. The Analyze Page