That's interesting. I had my doubts as to how useful pivot might be. It's good to see it backed up by examples and statistics.

I'm looking forward to what you have to say about dynamic cross tabs. I recently had to do a cross tab for an electronic voting system using proportional representation where each election can have a different number of candidates. The only solution I could come up with in the time available works but is so complicated as to be ridiculous.