Common question: how dimension order affects calculations?
Because calculation order appears only in cross-dim calculations, we can create following
sample cube (x’s are inputed):
The ??? marks the trouble spot. It can be:
Calculation sequence is defined by dimensions order. By pressing F7 on that cell you can see dimension order, and therefore the calc sequence.
+ and / are selected, because + and * are commutative. Got meself caught a couple of times.