Case study - Pivot Tables

Let's imagine a market stall selling fruit, veg, and perhaps eccentrically, tins of food. Data was collected over a few days at the start of May, and total sales (in £) recorded on a spreadsheet together with a record of the main weather conditions on each day


On the next page I will give a full pivot table showing all the data, and a smaller pivot table summerising by weather and type. Oh some pretty graphs too, because an extension of Pivot Tables is Pivot Charts