AnsweredAssumed Answered

YTD calculation

Question asked by tstaab on Aug 12, 2010
Latest reply on Aug 13, 2010 by philmodjunk

Title

YTD calculation

Post

I am a SQL and MS Access whizz and am trying to convert to Filemaker.  One of the things I'm struggling with is calculating YTD sales by store and product category.  The table I have has sales listed by store, product category, and week ending date.  What I want is to create a report that summarizes the YTD sales by store and product category and I have no idea how to do this.  In Access it would be a simple summary by store and product category.  Any help would be appreciated for this Filemaker newbie.  Thanks.  

Outcomes