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.