How to sum values by month from Date column?

Ask for Help
1

Hi,

What I want is to create a sum of sales by month. Those dates dates need to read and updated from a Date column.

Here is my table
image

For example, I want to see what is the TotalPrice for August, September etc.

How to achieve that?!

Best

2

Make a new column with a formula that formats the date as a string containing just the year and month. Then create a summary table grouped by that new column.

3

By the way, there is a recipe for getting year + month from a date here: Recipe for getting Months and Quarters from dates

4

If you need help with summary tables, we have a video guide here which covers a use case similar to this (totaling expenses by month): Summary Tables Guide - Grist Help Center