Pivotal tables in views

Is your feature request related to a problem? Please describe.

There are no ability to create view which summarize rows of selected data

Describe the solution you'd like

For example we have a table like this:

It needs to be added something like this to "Filter" section:

Column -> <select column1> -> select operator (contains or is equal) e.g value_A -> checkbox "summarize"
Column -> <select column2> -> select operator (contains or is equal) e.g value_E-> checkbox "summarize"
Column -> <select column3> -> select operator (contains or is equal) e.g. value_I-> checkbox "summarize"

After making several settings with filter we could get a result table like this:

This view could be used for analytics app further

Describe alternatives you've considered

No response

Additional context

No response

Start by locating the views and Filter section implementation in the Nextcloud Tables app, then determine how selected columns and operators are represented. The issue's example describes a summarized result table; done would require configurable filters, a summarize option, and the corresponding aggregated output for the selected data.