2 Replies Latest reply on Feb 1, 2012 6:17 AM by Gregg Thomas

    How to calculate %'s in financial statements using different denominators

    Gregg Thomas

      Is it possible for tableau to calculate %'s using different accounts as the denominator.  I've set up a financial statement, with the accounts and corresponding amounts.  Now i need to show what % that amount is of sales...

       

      For example, Food cost expense should be divided by total food sales.  But in this same view, I need to show labor %, which is labor expense divided by total sales.  I've tried numerous if/then, case & lookup formulas and can't see to get it to work. 

       

      Thanks!!