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.
