Pivot tables are great when you have alot of data that you want to quickly interpretThey work great for sales reports!The really cool thing is that you can add filters. i chose to filter by the names of my sale people. i liked that idea so much that i decided to pin point on one single salesman. That really comes in handy when you are making employee evaluations.