2 Replies Latest reply on Feb 14, 2013 6:46 AM by Frank Hayes

    Data Format Question - Calculation

    Frank Hayes

      I am trying to understand the best way to format data for use as a feed to Tableau.   If my data is formatted like this:


      Region     Type     Period     Qty

      US          Sales     Actual     100

      EU          Sales     Actual     200

      US          Cost       Actual     50

      EU          Cost       Actual     100

      US          Sales     Outlook     150

      EU          Sales     Outlook     150


      How can I calculate (Actual Sales - Outlook Sales) and (Actual Earnings = Actual Sales - Actual Cost)?


      I would appreciate any advice.


      Thank you.