how to calculate total of month

[ecabanas]

Hi,

I'm making a table to calculate the % of sales of each product comparing for the total units sold by the category.

I'm using the following formula to calculate the number of units sold in the month

=Sum (TOTAL(unit_quantity * quantity_delivered))

But as shown in the picture,  the amount is the addition of the 2 months selected

Any idea of how to show the total amount for each month?

Thanks'

[sunny_talwar]

Try this

=Sum(TOTAL <Month> unit_quantity * quantity_delivered)