4 Replies Latest reply: Aug 12, 2016 6:42 AM by Ga Baga RSS

    Semi additive measure in Chart

    Ga Baga

      Hello,

       

      I am trying to get the latest value every month and plot it in a chart against time.

      My data looks like the below,

       

      Date Sum(Stock)
      459
      1/8/201639
      1/29/201639
      1/1/201642
      1/22/201642
      1/15/201643
      2/5/201643
      2/19/201644
      2/26/201649
      2/12/201653
      3/5/201665

       

      And i am aware that Sum cannot be used as it is a snapshot of the weekly Stock. I tried using Only , but missing something to complete it. Please help. Attached the sample application here.

      Thanks in advance.