Understanding why absolute, relative and mixed referencing are used

Summarising and displaying data using: pivot tables, pivot charts, subtotals, groups