Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

how to calculate total of month

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

2019-05-09_12h37_34.png

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

 

Thanks'

1 Reply
sunny_talwar

Try this

=Sum(TOTAL <Month> unit_quantity * quantity_delivered)