10 Replies Latest reply on Oct 12, 2017 10:39 PM by .Kalin Stoimenov

    Running Total (Two Dimensions)

    .Kalin Stoimenov

      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 Banding
      EvalClosed (Days)1.0-10k2.10-20k3.20k-50k4.50k-100k5.100k-250k6.100k-1M7. 1m+Grand Total
      10/11/20160749111130715516 1,132
      10/11/20164560978102735013 925
      10/11/2016905726070434313 801
      10/11/20161355475561283191732
      10/11/20161804773650252651620
      10/11/2016225512455115233 649
      10/11/2016270433333921256 557
      10/11/2016315377313320225 488
      10/11/201636043431 51
      10/11/2016Total4,3194535392972757025,955
      10/11/20170623102143846918 1,039
      10/11/2017455356362304310 743
      10/11/2017904377366423115 664
      10/11/20171355024455515318 723
      10/11/2017180455476133298 633
      10/11/2017225458374332193 592
      10/11/20172704173637341951549
      10/11/20173154403554222311 585
      10/11/20173603716231 50
      10/11/2017Total3,9044385273302898915,578

       

       

      Running total result that i expect to see.:

       

         

      Result Expect to See
      EvalClosed (Days)1.0-10k2.10-20k3.20k-50k4.50k-100k5.100k-250k6.100k-1M7. 1m+
      10/11/201607498609901061111611321132
      10/11/2016451358154717791923202820572057
      10/11/2016901930217924812668281628582858
      10/11/20161352477278131443359353835893590
      10/11/20161802954329437073947415242084210
      10/11/20162253466385143154570479848574859
      10/11/20162703899431748205096534954145416
      10/11/20163154276472552615557583259025904
      10/11/2016360431947725311560858835953

      5955

      10/11/20170623725868952102110391039
      10/11/2017451158132315281642175417821782
      10/11/2017901595183321042260240324462446
      10/11/20171352097237927052912310831693169
      10/11/20171802552288132683508373338023802
      10/11/20172253010337638064078432243944394
      10/11/20172703427382942964602486549424943
      10/11/20173153867430448255153543955275528
      10/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!