Skip to main content
Craig Gurian 님이 #Tableau Desktop & Web Authoring에 질문했습니다

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개
  1. 2025년 2월 14일 오후 12:14

    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