Calculated Items and Solve Order – Excel PivotTables

This Mousebyte explains how to create a calculated item for a field within a PivotTable. A calculated item is a formula within field. It also explains how to change the solve order for calculated items where a cell has two or more possible calculations that it can perform. We hope you find this Mousebyte tasty […]

Read More

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