3 Replies Latest reply: May 8, 2014 7:02 AM by Mvrchowdary Rao RSS

    Create total without dimension

      Hi i am trying to do a sum of a field without a dimension

       

      My data looks like this:

       

      TranscactionIDCustomerIDOrderValue
      11111100
      2250
      34551
      4455150
      545556
      622467
      7579269
      89364

       

      I want to get the first ordervalue recorded for each customerid and compare it to the most recent ordervalue for that same customer and see if it is greater, if it is i want to count it.

       

      I can then show "95 orders placed that are greater than first order value" in a text object rather than a chart.

       

      How do i do this? Aggr? FirstSortedValue?

       

      Thank you.