Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)))