i am trying to calculate %'s in a financial statement. The tricky part is, the denominator changes depending on what expense line is being calculated. So, Food costs would be calculated taking total food costs / FOOD Sales. But Hourly labor would be calculated by taking total hourly labor / TOTAL Sales.
I'm having a hard time getting tableau to decipher between food sales and total sales. Can anyone help?