5 Replies Latest reply on Mar 26, 2019 5:52 AM by amar savale

    % Complete Calculated Field

    Tanner Watson

      Fairly new to Tableau so I apologize for this question.

       

      I have a field within Excel called Revenue Type.  Within this field are revenue, planned revenue, expenses, planned expenses.  Can I created a calculated field for % of actuals vs planned when all the data types are under one header?  If yes could someone share a quick example.

       

      My display in tableau would be as follows:

       

      Revenue     Planned Revenue     % Actual vs Planned

       

      Or do I need to have my revenue types under separate fields / headers.

       

      OK, sample data and workbook attached.  As stated I would like to add a column after Planned revenue and planned profit that lists the % of actuals. 

       

      Thanks