hi all, this is probably a classic question but I haven't seen a solution online yet. I'm making a straightforward chart export that displays
a summary field called INVOICES::s_Invoice GBP Total along the Y axis,
and this along the X axis -
Left ( MonthName ( INVOICES::INVOICE DATE ) ; 3 ) & " " & Year ( INVOICES::INVOICE DATE )
Attached is an example result. As you can see Jun 2016 is displayed twice (as there are two invoices made in June in the foundset).
How do I group these totals into month? Do I need to implement another summary field that runs from a calculation field by month and have that along the bottom or does this need scripting. I'll attach my script so far.