I use Pivot tables all of the time. My favorite is the ability to add calculations and I have a need to show value as % of total very often. One example of where i use them is looking at sales and GP by product and rep. In this pivot table I use % of total for sales to see what each rep and product contribute.