1 Reply Latest reply on Oct 28, 2016 3:44 PM by diego.medrano

    Running Sum on a Filtered View

    brian.chu

      My view has 6 dimensions and 1 measure (call it Income).

       

      I have filtered my view based on several criteria, including a logical table calculation for LAST()=0.

       

      I would like to create a running sum for all these rows where LAST is True. The running sum should reset at the first row level (call it Client).

       

      I have tried variations of IF [Last Entered] THEN RUNNING_SUM(SUM([INCOME]) END and editing the dimensions for the table calculation to calculate and restart from (i.e. Deepest, Client).

       

      I have also tried variations of LOD expressions, WINDOW_SUM, and TOTAL, but to no avail.

       

      This seems fairly straightforward but I am getting stuck. Any help would be appreciated. Sorry I can't post my workbook as the data is company private and sensitive. Thank you.