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

    Calculating Total Qty of items each month.

    gullfounder

      Title

      Calculating Total Qty of items each month.

      Post

           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.

            

      http://imgur.com/vdbmhEA

            

           I wanted to create a List of items per month based. and there Total QTy per month. Something like that.

            

      http://imgur.com/qUWXF8v

            

           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.