1 Reply Latest reply on Oct 19, 2012 8:52 AM by Alex Kerin

    Dynamic Tables/Numbers

    Zachary Hagopian

      I have pulled necessary data from Excel to create store P+L's on Tableau.   Basically, I am showing how to arive at a store's contribution margin starting with Total Sales, then subtracting cost of goods sold, occupancy cost, advertising costs, and payroll costs. 

       

      Now that I have this data in Tableau, I was wondering if there is an easy way to make the data "dynamic." 

       

      I would like to make it so that if I increase my total sales parameter, the other values change correspondingly.  Any help would be appreciated.  Thanks!