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!
You would need other calculations that are multiplied by the same parameter