13 Replies Latest reply: Jan 26, 2018 6:15 AM by Ali Ahmad RSS

    Create a line chart with total sales this week compared to last week

    Ali Ahmad

      Hey guys,

       

      I have this table below:

       

      1.PNG

       

      And what  I am trying to do is I want it to show the total amount for  the entire table on the row of jan 2018 and then as the total amount grows I want the next total amount on 2018 februar etc. as it goes.

       

      The key here is that I want to know what is the total of amount today. And then I want to see what is the total amount at that day and be able to see the development on a line chart.

       

      Is this something that I can solve / calculate front-end or would it best to make an aggregated table in the script and have that on the side?

       

      Any suggestions is welcomed!