7 Replies Latest reply on Oct 2, 2018 8:58 PM by Chinnala J

    Display transaction count and consolidated amount when filtered with a value present in two dimensions

    Chinnala J

      Hi All,

      Need some assistance. Any help is greatly appreciated.

       

      My Raw data looks something like this:

        

      IdFrom NameTo NameSent Amount
      1RobertChristine1.01
      2RichRobert2.01
      3JohnRich3.01
      4ChristineRobert4.01
      5EdwardCharles5.01
      6ChristineRobert6.01
      7RobertRich7.01
      8RobertRich8.01

      When filtered with a name (can be from 'From Name' or 'To Name') e.g. Robert, it should give some thing like this:

            

      Name FilterRobert
      NameTo VolTo AmountFrom VolFrom Amount
      Christine210.0211.01
      Rich12.01215.02

       

      Basically all the transactions that Robert got involved should be consolidated like above

       

      In Sample data, Robert sent some money to Christine. So, the From Vol should increment by 1 and From Amount should be increased by 1.01...

      Tried creating pivot table but not able to figure out a way to just get the names mapped to the filtered name in my view.

       

      Attaching the workbook thati started with. Any pointers will help.