The secrets to success unlock PivotTable reports.
You've already learned three of them: Check your source data before you begin, ask yourself what you need to know to figure out which fields to use, and remember to drop fields to display in rows in the row area, and so on.
The final secret is simple, but if you have a perfectionistic streak (and many of us do), it may take a little effort: Don't worry about arranging a layout in the "wrong" way!
Creating a PivotTable report is about moving stuff around to see how it looks. It's easy to move the pieces around as many times as you like. That's called "changing the layout," which usually just takes seconds to do, and it's an expected part of the process, like holding a picture up on several walls to see where it looks best.
