4 Replies Latest reply on Sep 4, 2018 11:07 PM by Shinichiro Murakami

    Recreate excel table in Tableau

    Owen Looney

      Does anyone know how to recreate this excel table  in Tableau? I am attempting to make it interactive, so all values on sheet 2 are parameters that can be changed and are interactive in tableau. I can get close but then I run into circular formatting errors when I get to the opening balance, closing balance, and the earnings, as the earnings are a % of the opening balance, and the closing balance is a summation of the opening balance, the contribution earnings, and the earnings. As the closing balance for one period is the opening balance for the next period I tried to do a lookup however I could not accurately recreate the table. If anyone knowns how to do so that would be great!