2 Replies Latest reply on Apr 17, 2013 7:44 AM by Shawn Aruch

    Compare values in different periods

    Shawn Aruch

      Hi,

       

      I'm trying to do a comparison of a dimension from period to period.

       

      I have a dimension - Agent, that represents who did some work for a client.

       

      I want to see where Agent was a specific value (A for example) for a period and then changed to any other value (not A or null).

       

      The result should be a list of clients where Agent A did work and then they switched to a different Agent.

       

      Thanks,

       

      Shawn