Calculate columnNo with two horizontal dims

[Anonymous]

Hi everyone!

Did anyone have a deal with calculating column number in case when we have two dimensions in the columns?

is it possible to calculate correctly number of each column? without changing the position of dims/expr.

Thanks.

[stabben23 · Accepted solution]

add total, ColumnNo(total)

[Anonymous]

Thanks!

[Anonymous]

Do you know how to calculate range sum in this case?

because rangesum(before(sum(Sales),1,ColumnNo(total)-1)) returns 0 in every column.

[stabben23]

like this

aggr(rangesum(above( sum(Sales),0,rowno(total))),Date)