Dickeson--Give Poor Roger's OLAP a Look

Pivot Table capabilities are built into MS Excel and Access, Lotus Approach and 1-2-3, Seagate Crystal Reporter and others. Sometimes they're called cross-tabs. In the freebie StarOffice from Sun Systems, they're Pilot Tables. All of them enable redimensioning columns and rows in database tables, so that rows become columns and vice versa. They may vary in mathematical functionality. Redimensioning a table may lead to aggregating table data into sums, averages, variances, standard deviations, etc. It truly is PROLAP.