count sales from previous month

[rainstorm90]

I currently have a table of sales and its date. I have created a field named month_1 which gets the previous month as shown below. Now I am trying to count the number of sales in every month. Sales are reported daily so I will need to sum them up. I want to have a list of month mapped with last month's sales. Any idea how can I do that?

Currently I am using:

=count({<[Date]={month_1}>}Sales)

but it's not working

[JordyWegman · Accepted solution]

Hi,

Or you need to place this value in a variable. Or you need a filter pane where you can filter on Month_1. Then you can just use Sum(Sales). You can't count Sales because then you count the rows and not the values in the rows.

Jordy

Climber