Question: how to create a percentage formula in tableau?
Answer: Select Analysis > Create Calculated Field.
Name the calculation. ... 
In the formula field, create a calculated field similar to the following and click OK: SUM( [Sales Furniture] ) / SUM( [Sales] )
Repeat steps 1-3 for each new percentage.
Create a new worksheet to display the percentage measures.