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

    Running sum with Last categorical value selected

    suresh ravi

      Hi,

       

      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)

       

      Output

      Week    Product    Sales

      4           Book          650

       

      Is this Possible. Please help me out.