6 Replies Latest reply: Jan 24, 2013 8:36 AM by Krzysztof Adamski RSS

    Running total of previous 5 days

      Hi guys,

       

      I will appreciate your help. I am trying to build an expression in pivot table to sum the values of last 5 days. As I load only values from working days weekends are not an issue.

       

      I have managed to get the value from 5th day in the past, but I do not know how to sum the range based on a date dimension. Moreover this one works only if you select at least 5 days

       

      =rangesum(above(TOTAL sum(Value), 5,RowNo()))