[flokie]

What about just plain old query() SQL i usually find the easiest vs. mucking around with pivot tables.

[Closi]

SQL is fine if you don't want to play with the data interactively - but that's the real benefit of Pivot Tables.

Things like drilling through, filtering/slicing, and then generating a graph, all in SaaS without having to run anything local.

[smusamashah]

Yes exactly, excel's Pivot tables and charts are more powerful.