3 Replies Latest reply on Dec 8, 2014 9:09 PM by Tharashasank Davuluru

    Running sum along weeks

    Rajdeep Panchal

      Hi

       

      I want to find out running total of a measure for 12 weeks. I am able to solve this using Lookup. However, I am only able to sum values for 12 weeks, once I reach to dates where future weeks are less, calculation breaks. Can someone give idea on how to solve this. I want to have ability to continue running sum even if weeks are less. I am attaching workbook, here is screen shot also

       

      Running sum.jpg