AnsweredAssumed Answered

Calculating Total Qty of items each month.

Question asked by gullfounder on Mar 17, 2014
Latest reply on Mar 17, 2014 by philmodjunk

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.

Outcomes