1 Reply Latest reply on Jul 27, 2012 1:52 PM by Tracy Rodgers

    Last record by date group

    Shay Hayo

      They want to show per Quarter/Month/Today the last figure per each period

      Example :

      Date qty

      15/1/2012 100

      18/1/2012 89

      05/2/2012 88

      18/2/2012 85

      01/3/2012 99

      10/3/2012 106

      01/04/2012 77


      Then :

      Q1 ->106

      Q2 -> 77

      or

      JANUARY 89

      February 85

      March 106


      I attached the twbx file. there is a way to do it?

        • 1. Re: Last record by date group
          Tracy Rodgers

          Hi Shay,

           

          By creating a calculated field similar to the following should get the desired result:

           

          if max([Date])=window_sum(max([Date])) then sum([Qty]) end

           

          Then, once this is placed on the view, right click on it and select the appropriate Compute Using.

           

          Hope this helps!

           

          -Tracy