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.