Running Totals in two calculated dimensional table

[Anonymous]

Colleagues, good day!

Need your consult for the next issue:

I've one simple table with Dates and Sales.

In front-end i've pivot table, which have two calculated dimensions -> to show sales by every weekend  (include all dates for corresponded week) and monthend (include all dates for corresponded month).

Task - calculate running totals sum. (using only set analysis and don't change position of dimensions)

Standard expression like RangeSum(Before(sum(Sales),1, ColumnNo(Total)-1)) doesn't work.

Will be glad for any idea how to solve this.

Necessary result  is in attached excel.

[rubenmarin]

Hi, have you tried?:

RangeSum(Before(TOTAL sum(Sales),1, ColumnNo(TOTAL)-1))

If the same week has to be counted on running totals:

RangeSum(Before(TOTAL sum(Sales),0, ColumnNo(TOTAL)))