3 Replies Latest reply on Nov 16, 2016 2:51 PM by Shinichiro Murakami

    Filtering a dimension using multiple dimensions

    Vishnu SAMAVEDULA

      Hi Folks,

       

      I am kinda stuck with a tricky filtering/calculated field problem:

       

      My Data:

       

      ID               Change ID              Amount

      1223           100                         $500

                          234                        $300

                          500                        $600

       

      1224            221                         $321

                          250                         $500

                          300                         $1000

                         

       

      Desired output:

       

      1223       500           $600

      1224       300           $1000

       

      Can someone help me out please ? Thanks a lot again,

       

      regards,

      V