The LOD Fixed will create a new - virtual - layer in your data - Fixed makes combinations of all the dimensions that precede the colon(:) and then aggregates them by what follows the colon - but the result is not an aggregate in itself -
if you want the fixed formula to consider 4 dimensions - then place all 4 before the colon - and it your case for each combination of
- `order.status` - `order.is_vip_order` - `order_rating` - `order.country_code
you will have a separate "virtual value" created by the LOD - you can use those in any other form of calcualtion
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.