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);
Below table is the target to be created in tableau
Do you have some sample data in a packaged workbook for the community to assist with?
Packaged workbooks: when, why, how
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...