How to get the running total of any year's last month (e.g. Dec-2019 ) in continuation with the next year's 1st month (e.g Jan-2020), and so on.

Question

Please note that I am applying Date (Year) Filter on the View, due to which it is not adding running total of any year's last month(Dec 2019) to next year 1st month (Jan 2020).

I want the Running total to be continued irrespective of the selection of Year(Date) Filter. How to get the running total of any year's last month (e.g. Dec-2019 ) in continuation with the next year's 1st month (e.g Jan-2020), and so on. Screenshot (584)

Ayinde Hammed · Answer

Hi @Abhaivir Singh​, what you can do is to change the date field in filter to table calc. filter by writing this LOOKUP(SUM([DATE]​), 0), convert it to dimension and then drag to filter.  ​ I just solve similar problem this morning, check the link below. ​ ​ https://community.tableau.com/s/question/0D74T000000tIMX/how-to-calculate-running-total-of-months-by-year-as-a-filter?s1oid=00DWL000003nQE9&s1nid=0DB4T000000GnPK&emkind=chatterBestAnswerNotification&s1uid=0054T000001OYMc&emtm=1597406345549&fromEmail=1&s1ext=0 If this help you in resolving the problem, please mark as correct to close the thread.​

How to get the running total of any year's last month (e.g. Dec-2019 ) in continuation with the next year's 1st month (e.g Jan-2020), and so on.

Tableau Desktop & Web Authoring

관련 학습

도움 더 받기