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

    Compare values in different periods

    Shawn Aruch



      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.