Hello,
I am trying different ways to get the running totals for two detentions but I can't - Please see the attached excel - where I am showing what I need to see as running total in Tableau.
Table that I have is:
Cost BandingCost BandingCost BandingCost BandingCost BandingCost BandingCost BandingCost BandingEvalClosed (Days)1.0-10k2.10-20k3.20k-50k4.50k-100k5.100k-250k6.100k-1M7. 1m+Grand Total10/11/20160749111130715516 1,13210/11/20164560978102735013 92510/11/2016905726070434313 80110/11/2016135547556128319173210/11/2016180477365025265162010/11/2016225512455115233 64910/11/2016270433333921256 55710/11/2016315377313320225 48810/11/201636043431 5110/11/2016Total4,3194535392972757025,95510/11/20170623102143846918 1,03910/11/2017455356362304310 74310/11/2017904377366423115 66410/11/20171355024455515318 72310/11/2017180455476133298 63310/11/2017225458374332193 59210/11/2017270417363734195154910/11/20173154403554222311 58510/11/20173603716231 5010/11/2017Total3,9044385273302898915,578
Running total result that i expect to see.:
Result Expect to SeeEvalClosed (Days)1.0-10k2.10-20k3.20k-50k4.50k-100k5.100k-250k6.100k-1M7. 1m+10/11/20160749860990106111161132113210/11/201645135815471779192320282057205710/11/201690193021792481266828162858285810/11/2016135247727813144335935383589359010/11/2016180295432943707394741524208421010/11/2016225346638514315457047984857485910/11/2016270389943174820509653495414541610/11/2016315427647255261555758325902590410/11/2016360431947725311560858835953
5955
10/11/2017062372586895210211039103910/11/201745115813231528164217541782178210/11/201790159518332104226024032446244610/11/2017135209723792705291231083169316910/11/2017180255228813268350837333802380210/11/2017225301033763806407843224394439410/11/2017270342738294296460248654942494310/11/2017315386743044825515354395527552810/11/20173603904434248695199548855775578
Essentially I am showing the rolling totals for both the column and the row. I hope this make sense.
In tableau I was able to calculate the running totals either on columns or rows, but couldn't do combination:
Any help will be appreciated.
Thank you!
