4 Replies Latest reply on Mar 17, 2014 1:13 PM by philmodjunk

    Calculating Total Qty of items each month.



      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.