AnsweredAssumed Answered

Subsummary of sales by month

Question asked by KurtSnow on Jan 26, 2018
Latest reply on Jan 30, 2018 by philmodjunk

I need to summarize sales by month for different book titles. Following this post Invoices report-grouping by year and month...how? I created a field called calcMonth with this formula: Date ( Month ( salesDate ) ; 1 ; Year (salesDate ) ). I placed it in a subsummary part using that same field. It displays properly, and there are results grouped by month. But rather than displaying just one instance of each month, there are duplicate months.

Outcomes