This content has been marked as final.
Show 2 replies

1. Re: Regarding Table Calculations using in formulas
Shinichiro Murakami Aug 9, 2018 10:46 PM (in response to gopi duppati)Hi Gopi
Could you please attach sample data as twbx format?
Thanks,
Shin

2. Re: Regarding Table Calculations using in formulas
Ankit Bansal Aug 12, 2018 1:05 AM (in response to gopi duppati)Gopi,
This formula can be fixed as:
running_sum(sum(IF FY End=FY Year then value end))
But since you are looking for data between 2 selected years. I would suggest create a calculated field TF as :
FY>= FY START and FY<= FY END
FY START/END I am assuming the parameters from which user will choose the years.
Then put this field on filter shelf and choose true.
After this you can calculate your running sum simply by choosing running_sum table calculation of tableau.
Thanks,
Ankit Bansal