I have data that is labeled as below:
Year Service Price
2018 Wash 10
2018 Pick Up 20
2019 Wash 15
2019 Pic Up 23
I want a subtotal/total that will add the total price for year 2018.
I have tried
=iif([subform].[form]![year]="2018",sum([subform].[form]![price]),)...