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?