2 Replies Latest reply on Jan 11, 2017 7:23 AM by Jayshree Dawrewar

    To get Revenue for Max Week(Latest week) for a user....

    Jayshree Dawrewar

      Hi All,

       

      I am working on an issue were I have to find out the Revenue for Max(week number) or latest week for a particular user. Like,

       

      User     Week          Revenue    

      A               50          100

                       51          200

                       52          300

      B              50          440

                       52          540

                      53          650

      C              50          70

                       53          10

                       51           80

       

      Output should be: (Hihlighted in bold as well above)

       

      User     Latest Week Revenue

      A               300

      B               650

      C               10

       

      I tried multiple ways like using LODs, Table Calculations but i am not able to get the desired output. Can anyone help in this?

       

      Thanks,

      Jayshree Dawrewar