Use the new, powerful PivotBy function in Excel It replaces Pivot tables in many cases. To use multiple fields, you need to either use table syntax or HSTACK function.
Download Sample file
Related videos
GetPivotData macro – Copy from pivot and paste as GetPivotData
Pivot Table Settings You Did Not Know!
Distinct count and custom layout in Pivot Table – using Data Model
Beyond AutoFilter – Use Slicers to filter Excel data and pivot tables
