Calculating Total Qty of items each month.
Hi, I am getting an issue regarding Calculating the Total of Each individual Item per month. I have created 2 tables in FileMaker. A Item table which will have ID and Date. Another table LineItems. which will be related to Item with via Items ID as FK in LineItems.
I wanted to create a List of items per month based. and there Total QTy per month. Something like that.
Of course its showing all the Items sum. I want it to have sum on each individual item i have that month. For Example: Marks are are repeated 2 times in second image. it shouldn't have only it showed once and its total sum.