5 Replies Latest reply on May 17, 2017 1:12 PM by Deepak Rai

    Running sum with Last categorical value selected

    suresh ravi



      I am facing this business scenario where I need to select the Week and it should show the corresponding dimension value but running total till that week.


      Week    Product    Sales   

      1          Book          200

      2          Pen              50     

      3          Paper         100

      4          Book           300

      5          Others         200


      If i select 4, I need to get Book and sales should be 650 (not $300)



      Week    Product    Sales

      4           Book          650


      Is this Possible. Please help me out.