This content has been marked as final. Show 5 replies
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.