Please Explain a bit from above example and fake data to help you.
I am looking to calculate both the ending and beginning balances in Tableau without using any external tools. The calculation field should be able to compute the $120, $80 etc and also post the same value as the beginning balance for the next year. (Assume the 2015 BB ($10) was calculated from the prior year 2014). Hope this helps and thank you for helping.