On the advanced end of the spectrum, pivot tables can also be used to perform simple projections; for instance, you can see how the revenue of your company has changed over time by viewing a line ...