Forgive me if I am not able to explain it correctly, let me put this in other way
If a person selects 2 quarters from the filter - Q3'2017 and Q4'2017...I want these numbers on the bar
bar 1 = beginning balance - 120,000 (beginning balance of 30-09-2017)
bar 2 = -18044 (sum of charged_off for 30-09-2017 & 31-12-2017)
bar 3 = -24555 (sum of closed for 30-09-2017 & 31-12-2017 )
bar 6 = ending balance - 1944 (ending balance for 31-12-2017)
Challenge is with bar 1 and bar 6. There has be some filter which picks only the beginning balance from the earliest quarter and some other filter that picks only the ending balance from the latest quarter. For rest - chargeoff. closed, new enrollment, we are already getting the aggregate values.
Shin, actually these are sample numbers which I put randomly, in actual data, it always matches..
To be honest, that's pretty bad, confusing example... anyways..
I modified excel file to make it work.
waterfall_SM_10.3.twbx 31.8 KB
That's awesome. It worked and saved my life. I could not have done on my own. Thank you so much Shin.