1 Reply Latest reply on Sep 5, 2018 2:53 PM by Patrick A Van Der Hyde

    Creating Liqudation Curves

    Rama Kadapala

      I am trying to create liquidation curves using the table1 below. I have created table2 using excel but having hard time creating it in tableau

       


      M0 in table2 is the grand total from table1 for each vintage

      M1 in table2 is the calculation of  M1=(M0- first vintage value) Ex1: for Jan18= (135,202-57,215); Ex2: for Feb18 = (103,131-47,462);

      M2 in table2 is calculation of  M2=(M1-Second vintage value) Ex1: for Jan18=(77,987-24,695);

      .

      .

      .

      Mn...................................

       

       

      Vint1.PNG

       

      Below table is the target to be created in tableau

      Vint2.PNG