7 Replies Latest reply on May 4, 2016 1:47 AM by AndrewJudd

    Column Chart Months


      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.


      Thanks all!



      Screen Shot 2016-05-03 at 22.56.27.png




      Screen Shot 2016-05-03 at 22.57.20.png