So if the base number is 100 and the annual number is 20 and we're looking out over 5 years, the calculated number would start with 100 and decrease by 20 each year until it gets to zero.
Seems like it should be easy by maybe I'm just dumb!
1 answer
You are not dumb - just new to tableau - I would use something like
sum(base) - index()*(sum(base)/ sum({fixed: countd(year))})
give it a try and when you have other questions ALWAYS post a twbx so we have something to work from
BTW see video https://www.youtube.com/watch?v=easBRzi9_bk and then the series https://jimdehner.com/bgs-beyond-getting-started-the-path-to-understanding-tableau/ they are FREE and will help transition to tableau