This content has been marked as final.
Show 3 replies

1. Re: Column Calculation from Excel to Tableau using calculated field
Okechukwu Ossai Aug 13, 2018 4:44 AM (in response to Benedict Sebastian)1 of 1 people found this helpfulHi Benedict,
This should do it for you.
[Year] in the sample dataset is an integer not a date. If it is a date in your real dataset then you will need to adjust the formula as required.
[Tableau Column]
IF ATTR([Year]) = 2017 THEN SUM([G])
ELSEIF ATTR([Year]) > 2017 THEN PREVIOUS_VALUE(SUM([C]))(PREVIOUS_VALUE(1)*SUM([B]))+SUM([F])
END
Hope this helps.
Ossai

2. Re: Column Calculation from Excel to Tableau using calculated field
Benedict Sebastian Aug 13, 2018 5:10 AM (in response to Okechukwu Ossai)Amazing thanks a lot Okechukwu

3. Re: Column Calculation from Excel to Tableau using calculated field
Okechukwu Ossai Aug 13, 2018 6:10 AM (in response to Benedict Sebastian)You're welcome Benedict. Glad it helped.