Grouping Text Fields in Excel PivotTables

In this Mousebyte we are are going to explain how to group text fields within a PivotTable.  We want to create a report summarising revenue for each brand of kitchen item sold through our store. This tutorial assumes you know how to create a PivotTable and can add fields to a PivotTable report. We hope you […]

Read More

Grouping Numeric Fields in Excel PivotTables

This Mousebyte explains how to group numeric data within an Excel PivotTable.  In our example we have a transaction database listing product sales which includes product price.  We want to analyse the number of sales in different price ranges, for example £0 -£5, £6-£10, £11-15. This tutorial assumes you know how to create PivotTables and add fields […]

Read More

Grouping Date Fields in Excel PivotTables

This Mousebytes explains how to group dates in a PivotTable. When you have a date field in a PivotTable it is often useful to group dates by week, month, quarter or year.  If you have Excel 2016 or later then you are in luck as dates are automatically grouped for you.  However, in earlier versions of […]

Read More