Let us go over these four steps one by one.Įnsuring that Your Date Values are in a Proper DATE FormatĪs you can see from the dataset, the dates are under the OrderDate column. Group the Pivot table to display total sales by Month for each year.Group the Pivot table to display total sales by Month.Create a Pivot table that will show date-wise total sales.Ensure your date values are in a proper DATE format.In order to do this, you need to move step by step. Let us say you have the following dataset:įrom the above dataset, let us assume you want to create a pivot table that will show month-wise total sales. How to Group By Month in Google Sheets Pivot Table You May Also Like the Following Tutorials:.Grouping the Pivot table Values by Month for Each Year.Grouping the Pivot Table Values by Month.Creating a Pivot Table to Show Date-wise Total Sales.Ensuring that Your Date Values are in a Proper DATE Format.