Click PivotTable in the Tables group and click OK (don't change any of the default settings).To create the example PivotTable, do the following: The PivotTable displays a grand total for each date and regionįigure A Our example data and initial PivotTable.The PivotTable sums sold values for the same date and region (sold values that don't share a region aren't summed).The PivotTable sorts the dates in a meaningful way.By default, the PivotTable gives you a good start toward grouping your data without much effort on your part: The PivotTable and data shown in Figure A contain only a few rows to keep things simple. LEARN MORE: Office 365 Consumer pricing and features Create the PivotTable I'm using Excel 2010 but noting significant differences between 20. You can work with almost any dated data or download the example 2010. I'll also show you a few of the less-than-obvious possibilities. In this article, I'll show you how to group a PivotTable by date components. If you're grouping by dates, you'll have lots of options, but all of the possibilities aren't as obvious as you might like. The technical side of things is simple - you insert a PivotTable and add the appropriate fields. How to clean up your Gmail inbox with this mass delete trick (free PDF)Ī PivotTable is a great way to summarize a lot of data.Excel is still a security headache after 30 years because of this one feature.15 highest-paying certifications for 2021.
