6 Replies Latest reply on Aug 4, 2017 11:00 AM by Jayson Osmars

    Calculating Grand total difference for Profit and Loss Statement

    Nathan Van Verst

      Hello,

       

      I am working on a Profit and Loss Statement dashboard.  Because Revenues are credits (negative values), I changed these numbers in the source excel sheet to show as a positive value in order to show correctly on the dashboard.  Expenses are naturally positive values.  So when I use the Grand total, it will sum Revenues + Expenses.  I would simply like to have the Grand Total (Net Income/Loss) show the difference between Revenues and Expenses.  Is there a simple way to have the Grand Total in Tableau accomplish this?

       

      Thank you,

       

      Nate