I have a pivot table, which has around 20 measures/expressions. I want to add a new column to the pivot table which will sum up the values in the last 10 expressions/measures.
Ofcourse one way is to add them like this
Column(10) + Column(11)+.............Column(20)
Is there some way to easily do this kind of summation. For example using rangesum etc?
Rangesum(column(10), column(11), ...) would be probably better then just adding the columns because NULL would be within the rangesum treated as 0 instead of returning NULL for the whole row. In cases that the columns could move it might be considerable to use the expression-labels instead of the column-index.
I think more wouldn't be possible unless you could use a dimension instead of many expressions and then enabling from partial sums (but I assume that wouldn't be suitable in your case).
