Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table with 3 dimensions, in which I would like to sum the "Dist" expression only for the rows that have "1" in their "load" expression in the row below. I did not manage to do it properly, such that if I collapse summation works.
Aggr ... , TOTAL ..., Below() ....
The lowest dimension is sorted, and "below" is determined by sorting.
Please advise.
Best
Below Expression might work
Sum(If(Load(Pre)=1, Dist))
Does not recognize the operator "Pre".
Did you test this?
As per your screenshot, i considered it to be a field in your model.
Ah ... that's the label. The field is "Load".
But, the condition should be that Load=1 in the row below the row whose "Dist" we are summing.
This works, per line: If(Below(Load)=1 or Below(Load)=0,Sum(Dist),0)
But when I collapse the dimension it sums to 0 ...