If you want to group the date column by month, you should use the Query function. Must Read: How to Use QUERY Function Similar to Pivot Table in Google Sheets You can generate a Pivot Table report in Google Sheets in Two ways – By using the Pivot Table menu command or using the Query function. Google Sheets has an alternative solution to this. At present, you can’t group a date column by month using the Pivot Menu Command. So it’s all about grouping dates in a column by month.įurther, the topic is relevant here because unlike Excel, Pivot Table is not much feature-packed in Google Sheets. But my data has no month column instead it has a column with dates. I want to create a pivot table that summarises the data month wise. How to create a month wise Pivot Table report in Google Sheets? I know this topic would not be a matter of discussion here if I’m talking about a spreadsheet table that has already a column with month names entered.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |