3 Replies Latest reply on Aug 19, 2016 10:30 AM by Christopher McKinnish

    Create Calculation based on Totals

    Christopher McKinnish

      Simple setup.   Note:  This is not excel.

       

      Each row for expense and revenue is a measure, not calculated.  The O/R column is a simple calculation [Expense/Revenue]

       

      Now I have Totals Setup.  Of course the Total Row for Expense and Revenue is perfect, and of course the OR total row is not. 

       

      What is should be is the Total Expense divided by the Total Revenue.

       

      Does anyone know how I can do this in this single view?