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 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.