5 Replies Latest reply: Aug 19, 2011 12:12 PM by Oleg Troyansky RSS

    Set Analysis to calculate inter records

    Doron Reichenberg

      suppose I have the following table:

       

      TicketID, Sales

       

       

      TicketID is running from 1 to 1000 and assuming it's sorted ascending.

       

      I want to compare the sales of any ticket to the sales of the following X tickets.for Example:

       

      If the sales of the current ticket is larger than the sales of obe of the following 5 tickets, then 1, otherwise, 0.

       

      Can I please post an example with set analysis of how it can be done?