Access: Adding Calculated Field

I would like to add a conditional calculated field in a table. The table contains dates, products and product-sales-values. I am looking for a calculated field to calculate the weight of the Product sales, per date, regardless of the number of rows of data per date. e.g. For Each month the aggregate product's sales for January as a percent of the total (all) products' sales for January