4 Replies Latest reply on Aug 20, 2018 10:41 AM by Myni V

    Calculation of Target Vs sum of Actuals based on ID.(Conditional sum of line items)

    Myni V

      Hello

       

      My data looks something like below. classification is only at target level.    

          

      ClassificationIDAmountType
      Roads1100Target
      Education20300Target
      110Actual
      120Actual
      2010Actual
      2040Actual

       

      If I want the target vs actual for the classification type Road, it should get all the IDs associated with that Classification in target. and using that ID it should sum up all the Actuals. The output should look something like below.

       

          

      ClassificationIDActual AmountTarget Amount
      Roads130100
      Education2050300

       

      By Using the above data table I am gonna create Visualizations like bar charts to show actual vs target by classification.

       

       

      This might be silly but I am new to tableau and Not sure how to achieve this. Your help is highly appreciated.