I have created a dashboard which has a table displaying thousand rows. I want to group rows on a specific column. Once the whole table is broken into many groups I want to sum values of that column.
I am pulling this data from PDI with two parameters (timespan). I want to have another field in which user will type column name. I do not want to query PDI and don't want to group everything on PDI end.
Is there a way to achieve this?