0 Replies Latest reply on Sep 29, 2013 3:04 PM by Xiaodong Han

    Calculate Actual vs. Expected result

    Xiaodong Han

      I'm trying to duplated a calculation in Excel in Tableau.  The logic is fairly simple.  Say Control group grow by 5% in the post testing period, the Testing group is expected to grow at least 5%.  (Test Group pre sales)*105%=Expected Sales for test group.  Please see attached Excel file.

       

      In Tableau, I have time period, sales and stoer type (Test/Control).  How do I make this logic to happen?  I included sample raw data in the file too.