6 Replies Latest reply on Sep 9, 2016 10:19 AM by Rashmi G

    Running Sum Logic / Conditional Filters based on columns

    Rashmi G

      Hi Folks - I have a requirement as follows : I need Running Sum of Participated Act column . In screenshot 1 the week id: 4851 has 296(refer second column) as the answer , but in screenshot 2 for the same week id I am getting 275. This is because it is considering only the weeks that are in the view.

       

      Is it possible in Tableau to consider 4821 as the base week for this calculation ? Also the running sum should work if any other week ids are selected as well.

       

      I have attached the sample excel sheet which I am using . Please let me know if this is possible.

      screenshot 1

      screenshot 2

       

      Thank you,

      Rashmi