Microsoft® Office Access™ 2007 Plain & Simple

Pivoting a PivotTable

Perhaps the biggest benefit of presenting your data using PivotTables is that you can change the data’s organization on the fly, creating literally dozens of different forms from a single data set! All you have to do is drag the header of the field you want to move to its new position—when you release the mouse button Access examines the PivotTable’s new structure and rearranges the data to match it. If previously you had listed sales by Country and then by product Category, you could drag the Category field header to the left of the Country field header to reverse the grouping.

Reorganize PivotTable Data

1. Display the forms in ...