4 Replies Latest reply on Dec 8, 2017 9:40 AM by Shinichiro Murakami

    Help with Calc to determine the pattern

    shwetha sarma

      Hello, PFA excel sheet. I'm having trouble determining the calc for the total sales.

       

      I want the yearly sale number to increase as

      2019: IF SEQ = 4, then  Total SalesfromTableau *.89

      2020: IF SEQ = 5 then Total SalesfromTableau*.89 + lag1(Total SalesfromTableau)*.803

      2021: IF SEQ = 6 then Total SalesfromTableau*.89 + lag1(Total SalesfromTableau)*.803 +lag2(Total SalesfromTableau)*.633

       

      As year increases the complexity increases. Also, years from 2016-18 are not considered.

       

      Also, I have to add that Total SalesfromTableau  is a calculated field that is being done in tableau. I want to do this calc in tableau and not outside because it uses a lot of parameters.

       

      I have better explanation in the excel sheet. Please help. I will add details as questions are asked.