Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have these dimensions: group, filenumber, date
expression: rangesum(before(payment, 0, ColumnNo()))
now:
i want to leave out the filenumber dimension.. but the expression should still give the sum of the rangesum based on the filenumber
SUM(AGGR(rangesum(before(payment, 0, ColumnNo())),filenumber)
is not working
Perhaps you need a set analysis statement that doesn't select any filenumber.
Like this statement
rangesum({$<filenumber = >} before(payment, 0, ColumnNo())
I doubt the exact code will work, but I hope it helps to find the correct one