4 Replies Latest reply: Sep 5, 2012 3:40 AM by Florian Pennetzdorfer RSS

    Comparison between 2 independant dimensions

    Florian Pennetzdorfer

      Hey,

       

      Probably an easy one, but I can't figure out ...

       

      In my Sales application I've got two different fields for Sales representative:

      • HistoricSalesRep from Sales table
      • CurrentSalesRep from Customer master table

       

      Now I would like to compare Sales between those 2 fields. For example:

       

      Sales RepHistoricCurrent
      A1,2651,150
      B2,4582,581
      C1,8591,737
      D5,8876,001
      Total11,46911,469

       

      Does anybody know how to achieve that?

       

      Regards,

      Florian