Feature Request: Advanced Pivot Table for Data Summarization
So maybe a weird feature request/product enhancement but I think pairs well. I think it could be insanely valuable to be able create a report like table that digests all the rows from another table. Could be same workbook im not sure. The problem now is that there is alot of context at a row basis, but its a bit of a process to export put in sheets, or import into claude to do that analysis. I think if you were able to create some sort of pivot table functionality from existing table data in another table, and could set a date ranges etc could be really helpful. Im thinking on top of this a way to feed all rows from one column into somewhere where a summarization could be made. Perhaps like Chat GPT o3 pro, etc. So you could do basically like a pivot table and then a summary of all that data as like an executive brief. Kinda like how airOps creates a project brief. An example for this would be if you had a table for gong calls , being able to summarize all the calls within a specific time frame for insights would be super insightful. Sure you can set up prompt now to review trasncripts and look to identify stuff you want (competitor mentions/ prcing rebuttals) But the holistic overview report on a monthly basis on those calls could be helpful.