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

    Column Chart Months

    AndrewJudd

      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