Pivot table - how to best create

Wondering if there is a way to create a pivot table from data? I’m sure you’ll say that it is possible with JS.

But what is appealing to me with Appsmith is that I can do a lot with my limited knowledge.
I’ve got a lot of data that I’d like to be able to work with. We use Redash to do some analysis with sql and the built in visualizations, and I see/hope that Appsmith is a way to take our data to a new level by actually being able to build a UI on top of the data to be able to take actions via APIs.

Prob extends upon - Table groupings

Hi @jo-cpa :wave:
This is actually not possible today. I’ve added a feature request for a new pivot table widget that can achieve this. Do drop a note with your use case