Pivot Tables are a very fast, neat way of analysing sales data like this:If you would like a formatted example of how it works, you can download our surprisingle inexpensive spreadsheet: When you swap in your own data, don't forget to refresh the Pivot Ta ...