1) I am creating a Pivot table that has [Regions] dimension in Rows and four measures namely sum[Sales], sum([Sales Quantity]), sum([Buy Price]), sum([Buy Quantiity]) in Columns. Pivot table: 3. Right-click the cell and select Group from the drop-down menu. When you create a PivotTable that is based on Excel data, you can group the data in the PivotTable. You will get a pop-up window to group dates. I'm trying the produce the following desired output. Microsoft 365 Apps or Office 365 Business. The Group Field feature allows us to quickly group a field of dates into Year, Quarters, Months, etc.This means that the source data does NOT need to contain columns with the year, quarter or month name. Figure 1- How to Group Pivot Table Data by Year. It's not pretty, but it works! In a pivot table, you can group dates, number and text fields. How can I group a range of column headers and call them say 'States' and then from that run a pivot table report to find out what states my customers work in and have a cout of this also? In the PivotTable, right-click a value and select Group. Here is a