如何以编程方式快速构建即席查询？

I've used Excel PivotTable to analyze data from my database because it allows me to "slice and dice" very quickly. As we know what is in our database tables, we all can write SQL queries that do what PivotTable does. I've used Excel PivotTable to analyze data from