Pivotal tables in views

[intervisionlord]

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:	column1	column2	column3
value_A	value_D	value_H
value_A	value_D	value_I
value_B	value_E	value_I
value_B	value_F	value_J
value_C	value_G	value_J

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:

column1	column2	column3
2	1	2

This view could be used for analytics app further

Describe alternatives you've considered

No response

Additional context

No response