Accumulation in a Pivot table

[#1]

Hey,

I want to build an expression where I can see the accumulated sum of one field. I started with an RangeSum function and everthing looks fine but on the second view I saw that when I click on a date the accumulation will start from the beginning. Is there a possibility to create a function which gives back the "total" accumulation when I click on a specific date.

Please look at my example...

Thank you!

PS. My goal is to build a function in the frontend and not in the script enviroment.

[sunny_talwar · Accepted solution]

I cannot see your qvw (as I am working with Personal Edition), but try something like this:

If(Sum(Sales) > 0, RangeSum(Above(TOTAL Sum({<DateField = >}Sales), 0, RowNo(TOTAL))))