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개
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