News

Select Insert > PivotTable. In the Create PivotTable dialogue, in the Table/Range field, select the range of data you want to analyze. In the Location field, select the first cell of the worksheet ...
I prefer to create PivotTables on new ... so that it sits tidily near your PivotTable. In my case, I've inserted some extra rows above my table, and moved the timeline to the top of my worksheet.