Hi,
I have a problem I cant seem to solve.
I have a pivot table with
Account number as Row dimension and Date as Column dimenion. When I use
if(Accountnumber= '76999990', aggr(RangeSum(above (Sum({<Yearbc, Accountnumber= {">=40000000"}, Accountnumber= {"<=76999990"}>}Betrag), 0, rowNo(total))), Accountnumber), sum(Amount))
it all works fine and the range is summed under account number 76999990.
BUT
when I add the date column dimension in the pivot table, it stops accumulating the range at 76999990.
Can anyone please help me?
